Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Execute a stored procedure from OCI = SORRY
Sorry, I see that you did post it..My news server was a little behind..( sometimes I'm a little behind myself..)
TurkBear <jgreco1_at_mn.rr.com> wrote:
>
>Thanks..Can you post your procedure code?
>
>
>"Rolf C Stadheim" <r-stadhe_at_online.no> wrote:
>
>>The error messages were (translated from my locale to English):
>>
>>For 'EXECUTE INSERT_ROOM(45)' and 'EXEC SQL INSERT_ROOM(45)':
>>ORA-00900 INVALID SQL STATEMENT
>>
>>For 'BEGIN INSERT_ROOM(45) END;':
>>ORA-06550: ERROR LINE 1 CHAR -- PLS-00103: END OCCURRED WHERE ONE OF THE
>>FOLLOWING WERE EXPECTED:
>>:= . ( % ;
>>
>>For 'BEGIN INSERT_ROOM(45);':
>>ORA-06550 :
>>
>>Regards,
>>Rolf
>>
>>"TurkBear" <jgreco1_at_mn.rr.com> skrev i melding
>>news:r7pb3u8c3a3rpfdmpjsjjnt2l2j7g4m7t2_at_4ax.com...
>>>
>>> Please list the varying error messages..
>>> meanwhile,
>>> Check:
>>> Are you logged in as the owner of the procedure?
>>> If not, use the fully qualified name SCHEMAOWNER.INSERT_ROOM(), assuming
>>you have permission to use it, and to insert into
>>> the table
>>> the syntax ( if room is a NUMBER ) is EXEC INSERT_ROOM(45)
>>>
>>>
>>> "Rolf C Stadheim" <r-stadhe_at_online.no> wrote:
>>>
>>> >How can I execute a stored procedure (a non-select procedure that inserts
>>a
>>> >row) from an OCI C-routine?
>>> >
>>> >I have tried
>>> >
>>> >'EXECUTE INSERT_ROOM(45)',
>>> >'EXEC SQL INSERT_ROOM(45)',
>>> >'BEGIN INSERT_ROOM(45) END;',
>>> >'BEGIN INSERT_ROOM(45);'
>>> >
>>> >but all fails with varying error-messages.
>>> >
>>> >I'm using the Oracle 7.3 OCI libraries.
>>> >
>>> >RCS
>>> >
>>>
>>>
>>>
>>> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
>>> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
>>> Check out our new Unlimited Server. No Download or Time Limits!
>>> -----== Over 80,000 Newsgroups - 19 Different Servers! ==-----
>>
>
>
>
>-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
>http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> Check out our new Unlimited Server. No Download or Time Limits!
>-----== Over 80,000 Newsgroups - 19 Different Servers! ==-----
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Mon Jan 07 2002 - 13:20:46 CST