Home » SQL & PL/SQL » SQL & PL/SQL » regarding bulk collect
regarding bulk collect [message #193127] Fri, 15 September 2006 00:10 Go to next message
anithalakshmi
Messages: 9
Registered: August 2006
Junior Member
Hi all,
I had created a procedure using "bulk collect" concept .The procedure compiled with out errors but it is giving an error when I am trying to execute it.

The error messages are

EXCEPTION OCCURRED AT LABEL - UPDT_ORG_SHP_DT STATEMENT - Update Orig Ship Dt Cursor

ORA-01722: invalid number

I had introduced this bulk collect concept only in one label and I am getting errors from that label only.But the procedure is executing with out any errors with out bulk collect concept.
Can any one suggest me what should I do in order to execute the procedure with out errors.
Re: regarding bulk collect [message #193150 is a reply to message #193127] Fri, 15 September 2006 01:35 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Quote:

Can any one suggest me what should I do
show us the code?
Previous Topic: CLOB wrong character
Next Topic: Weak REF CURSOR and %ROWTYPE
Goto Forum:
  


Current Time: Mon Dec 05 14:46:36 CST 2016

Total time taken to generate the page: 0.17405 seconds