TOraclePackage error

[lynn_sai]

Hi
I have an Oracle function CAN_UPDATE to check the user privileges, and I use TOraclePackage.CallBooleanFunction to call it; However, I have the error:
" PLS-06550: identifier 'CAN_UPDATE' must be declare........"

Please help...

Thanks.

 

[Marco Kalter]

You can use the TOraclePackage.Debug property or the Oracle Monitor utility to find out what PL/SQL Block is executed when this error occurs. This will probably explain things.

------------------
Marco Kalter
Allround Automations

 

[lynn_sai]

now I solved that problem. However, I have another problem when I use CallBooleanFunctioin from TOraclePackage. My boolean function suppose to return a True boolean value; However, whenever I call:

CanEdit : Boolean;

CanEdit := OraclePackage1.CallBooleanFunction('myfunction')
it always returns a FALSE value

Do I miss anything here ???

 

[Marco Kalter]

I'm not sure. Maybe you can use the same Debug property and verify that the function returns the correct results when called like that.

------------------
Marco Kalter
Allround Automations

 

[lynn_sai]

Hi Marco,
My oracle function is:

Function MyFunction Return Boolean

As you can see, this function has no param, all it has to do is just to return a boolean value. This is the first time I call oracle function in delphi, and I'm using TOraclePackage to call this function, and I'm not sure how to do it. Please help me out here.... Thanks.

 

[Marco Kalter]

See this FAQ topic for more information about calling stored functions.

------------------
Marco Kalter
Allround Automations