Board index » delphi » Delphi 7 X Oracle 9i

2005-03-29 08:00:10 PM
delphi24
Hi All. I need some help. My problem is:
<<< Oracle Part>>>
My_Package is a package with some functions SF_A, SF_B... SF_Z.
Hi_User is the owner user, and Lo_User is just one more user.
Lo_User have the Execute privilege for My_Package.
<<< Delphi Part>>>
DBExpress, SQLConnection using Hi_User logon properties.
SQLStoredProc works fine.
But...
DBExpress, SQLConnection using Lo_User logon properties
does not work. See below:
---------------------------
Error
---------------------------
SQL Server Error: ORA-06550: line 1, column 13:
PLS-00201: identifier 'MY_PACKAGE.SF_A' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored.
---------------------------
OK
---------------------------
Is it a DBExpress bug?
How can I to solve this problem?
Thanks.
Ricardo Carmo.
 

Done. ( Create synonym ... )
Ricardo Carmo
"Ricardo Carmo" <XXXX@XXXXX.COM>escreveu na mensagem