Passing values to a stored procedure in Oracle

HCL Domino Domino Forum
1

Using Lotus Script, Can anyone explain how to pass a value to a stored procedure in Oracle 8. I need to place a button on a form that will take the text value of “FIELD-A” and pass it to "VALUE-A"in a stored procedure. I do not need anything passed back to the Notes client. I just need to pass a value to the procedure and let it do it’s thing.

Thanks!

2

Subject: Passing values to a stored procedure in Oracle

If you look at the LSX LotusScript classes (which you get with LEI or can download for free), you need to use these to connect to Oracle stored procedures. If you search the Lotus Support database there are technotes showing coding examples on how to do this.

3

Subject: RE: Passing values to a stored procedure in Oracle

thanks Melissa. I have no problem connecting, I need to pass a value and, forgive my ignorance I’m not an Oracle guru, “kick” the procedure off. I checked everywhere. Most IBM’s samples reference DB2. I found many DB2 instructions are somewhat different. I can connect and disconnect without error but the stored procedure doesn’t do anything. If I launch the stored procedure from SQL+ it works fine.

4

Subject: RESOLVED!

I had the following lined commented out. I remove the comment flag and it worked!

count = conn.call(input_Parameters, 1, result_set)

Thanks!