OCI - obindps call for multiple rows insert

I have the following code (steps)

1. oparse
2. obndrn (for 2 columns)
3. obindps ( for 1 long column)
4. oexec
5. ogetpi
6. osetpi (complete insert for one row)
7. change bind values and go to step 2

I can insert only one row with the above code. While inserting a second row, I get a GPF. If I start again at step 1 for 2nd row, the insertion is through with no errors. Any reason why?
I do not want to parse the same SQL stmt for each row.

Sridhar

sridhar_dvjsAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
HaukeConnect With a Mentor Commented:
I think the reason is the LONG column.
I had the same problem with OCI7.3.
Processing multi rows containing LOB columns works with OCI8.

You don't need to parse the statement for each row. Parse the statement and bind the variables once and execute after changing the values many times.
0
 
sridhar_dvjsAuthor Commented:
I am using Oracle 7.3.4.2. Are you saying that there is no solution to my problem for this Oracle version?

Sridhar
0
 
HaukeCommented:
Yes, I think so.
0
All Courses

From novice to tech pro — start learning today.