Jaguar, Oracle, PB7 DataWindow Stored Procedure

[Tony Brooks]

Does Anyone know how to update/insert records in an Oracle 8.04 database
using the Oracle native drivers and a datawindow created based on a stored
procedure?

Background Info:
1) The datawindow is based on a stored procedure and the update properties
for the datawindow
have NOT been enabled.

2) The datawindow has three 3 stored procedures associated with it, one
each for update, insert,
delete.

3) Currently using Jaguar 3.5 on NT Workstation.

5) The stored procedure retrieves, displays, and updates the data fine in
both development and run-
time environments, but when the a new row is inserted the update is
called from the client I get an
return of null displayed on the screen and nothing else.

Please help.

--
From the desk of:

Antonio Brooks
Information Technology Consultant

[Suresh Subrmaniam]

Hi,

I am using Oracle 7.1 and it worked perfectly for me. I was not inserting
a row, but I was updating a row and updated more than 1 table using
stored procedures. But I have enabled Update option and then set the
stored procedure option

As far I know I think you have set update to true. Otherwise Update event
will not fire. If update is set to true and sp updates are set, I think in the

sqlpreview event it uses the stored procedure. This is my guess.Larry,Dave,Jim

can provide you with more info.

Thanks