11 Aug
2001
11 Aug
'01
10:45 p.m.
How can i call a stored procedure from another schema. I only have permission to call a stored procedure from an admin schema and not the schema it resides in. When I set up the Z Oracle Stored Procedure, it's ok with just the name of the procedure but when I test it, it says "[myprocdure] is not a valid stored procedure name." In SQLPlus I can call it from the admin schema without specifying the schema name it actually lives in. I tried specifying "schema.myprocedure" as the Procedure Name and that didn't work. Any ideas? Walter