Stored procs and SetVariable

[JosAikema]

When I try to set an variable with SetVariable I got an error-message:

PLS-00302: component '' must be declared

but I don't see any DeclareVariable method within TOraclePackage like in TOracleDataset

jos

 

[nboodram]

Try taking a look at the following FAQ:
http://www.allroundautomations.com/ubb/Forum1/HTML/000002.html

Natalie

 

[JosAikema]

Thanks for your answer but that FAQ doesn't answer my question:

How to declare a variable within a TOraclePackage ?

Jos

 

[Marco Kalter]

The GetVariable and SetVariable functions apply to public, global variables in the package.

You will get a PL/SQL error if the value of the PackageName property of the TOraclePackage or the value of the VariableName parameter passed to SetVariable is empty or otherwise incorrect.

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

 

[JosAikema]

What do you mean by public or global? I want to set bind-variables. How can I do that? (i don't like the examples in de package wizard)

Jos Aikema