Recent content by TomH

Actually - I nailed it yesterday. The book I got on PL/SQL was very helpful for structure. I just created an anonymous block declared my variables, assigned values to them and called the procedure passing the variables as arguments. Thanks to the fact that the TOracleQuery can run PL/SQL, I'm...

It isn't a rights issue, but I just figured out that what I need to call is in the procedures secion o fthe oracle schema mgr. It is NOT a package... Is there a way to put this procedure into a package? Or is there an easier way to call a procedure? I know I sound like an idiot, but I really...

Marco, I tried the wizard, but for some reason, the package doesn't show up in the selection list... Can you please point me to somewhere where I can find an example of a PL/SQL block to do this sort of thing?

Im trying to call a function defined in Oracle and I have been doing this fine with other packages, but this one has three of its parameters defined as arrays: Most of the parameters are defined like this: var1 IN OUT VARCHAR2, but the ones I am having trouble with are defined like this...