problem with alter session, procedures doesnt work.

problem with alter session, procedures doesnt work.

Postby Vassagus » Mon 05 Dec 2005 15:58

Im trying to use Users from the database, but i dont want to create synonyms for each user, so im reprograming the login of the system on delphi, and i use something like this:

ALTER SESSION SET CURRENT_SCHEMA=MAINSCHEMA;

now i log in into the system with the user TEST, and evetithing is working, but the stored procedures failed to execute. Oracle return this exception ORA-04043: the object TEST doesnt exist.

The only solution that i have is to create all synonyms or, change all the code of the system for SCHEMA.PROCEDURE.

I think that maybe dbxpress is asuming that the procedure is TEST.PROCEDURE. so i need a way to fix it. pls
Vassagus
 

Return to dbExpress driver for Oracle