OraFAQ Forum: SQL & PL/SQL » ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind (xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind [message #626579]

Wed, 29 October 2014 07:57

arora.charan
Messages: 2
Registered: April 2012
Location: India

Junior Member

please Check this error and revert back me...

ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind

DECLARE
CURSOR c1 IS
SELECT doc_id,doc_scanned_copy
FROM DOCS_COMP_DOCUMENTS;
BEGIN
FOR i IN c1 LOOP
EXPORT_IMAGE('C:\IMG\'||i.doc_id||'.jpg',i.doc_scanned_copy);
END LOOP;
END;

ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bi

Report message to a moderator

Re: ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind [message #626581 is a reply to message #626579]

Wed, 29 October 2014 08:13

sandeep_orafaq
Messages: 88
Registered: September 2014

Member

Please Format your code. Looks like there are already few threads in the Forum regarding the same error code. Can you please do a search. It seems the size of some declared variable has Problem. What is EXPORT_IMAGE?

http://www.orafaq.com/forum/t/164863/
[/link]

Report message to a moderator

Re: ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind [message #626582 is a reply to message #626579]

Wed, 29 October 2014 08:14

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

These are the errors I get:

ERROR at line 4:
ORA-06550: line 4, column 6:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 3, column 1:
PL/SQL: SQL Statement ignored
ORA-06550: line 7, column 25:
PLS-00364: loop index variable 'I' use is invalid
ORA-06550: line 7, column 1:
PL/SQL: Statement ignored

Report message to a moderator