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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

HaukeCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.