Re: Sql Server stored procedure strikes back

Hi as I know from oracle you not only have to name the procedure itself, you also have to give the tablespace/userspace with the procedures name. This means that you may have a procedure named "myproc" that was created by user "me" in tablespace "user_data". To acces a so named stored procedure the right call would be "me.myproc (...)". And it's also important that you have access (by default) to the named tablespace (remember: the running php/user may not be the user who created the stored procedure) helped? Peter -- _______________________________________________________________________ mailto:Peter.Schupp@object-it.de Privat: STZ object-IT Tel. 0711 18 39 78 6 | Kirchheimer Str. 18 Postfach 10 43 62 Fax 0711 18 39 68 7 | 73760 Ostfildern-Ruit D-70038 Stuttgart D2 0172 9 06 71 62 | Tel 0711 44 16 06 5 PGP Key available at: http://wwwkeys.de.pgp.net _______________________________________________________________________