Re: calling oracle storesd procedure from smalltalk

There use to be an example in the Oracle VW DB EXDI manual. Basically you send preparePLSQL: and give it a little PLSQL string that calls your stored procedure and puts the answer in a variable. Then you send another command to get the variable contents.

Cursors are automatic. So I am not sure what you are asking here. If you want to cache, and reuse the cursor, then you should look at a third party DB Management Framework.

There is one at http://home.flash.net/~lopemanc/

There are also plenty of others.

MEL wrote:

> Hi,
>
> I am working with visual works 5i.2 with an oracle DataBase 8i.
> I have somme stored procedure to manage data in the database.
>
> Can anybody send me a piece of smalltak code to call a stored procedure
> and retrieve the result.
> Have you an idee in how can I manage Oracle cursor in smalltalk
>
> Thank you for any help
>
> Mahmoud.
  Received on Wed Apr 11 2001 - 18:43:00 CEST