problem with alter session, procedures doesnt work.

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
Vassagus

problem with alter session, procedures doesnt work.

Post by 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

Post Reply