Home » SQL & PL/SQL » SQL & PL/SQL » ORA-06502: PL/SQL: numeric or value error
ORA-06502: PL/SQL: numeric or value error [message #382748] Sat, 24 January 2009 02:09 Go to next message
sanjeev.sharda
Messages: 14
Registered: December 2008
Location: Ludhiana
Junior Member

Please help me abt this...
CREATE TABLE DOCS_COMP_DOCUMENTS
( DOC_ID VARCHAR2(10),
  DOC_NAME VARCHAR2(100),
  DOC_SCANNED_COPY LONG RAW,
  FILE_NAME VARCHAR2(50),
  FILE_EXTENSION VARCHAR2(3)
);

DECLARE
   CURSOR c
   IS
      SELECT doc_id, doc_name, doc_scanned_copy, file_name, file_extension
        FROM docs_comp_documents
       WHERE doc_id = '1';

   rc   c%ROWTYPE;
BEGIN
   OPEN c;

   LOOP
      FETCH c
       INTO rc;

      EXIT WHEN c%NOTFOUND;

      INSERT INTO docs_comp_documents
                  (doc_id, doc_name, doc_scanned_copy, file_name,
                   file_extension
                  )
           VALUES ('10', rc.doc_name, rc.doc_scanned_copy, rc.file_name,
                   rc.file_extension
                  );
   END LOOP;
END;


[LF has merged topics, deleted a duplicate message, formated code and applied [code] tags to improve readability]

[Updated on: Sat, 24 January 2009 06:49] by Moderator

Report message to a moderator

Re: Can Anyone help me...ORA-06502: PL/SQL: numeric or value error & ORA-06512: at line 11 [message #382756 is a reply to message #382748] Sat, 24 January 2009 06:26 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Please provide your four digit database version.

Re: ORA-06502: PL/SQL: numeric or value error & ORA-06512: at line 11 [message #382759 is a reply to message #382748] Sat, 24 January 2009 06:44 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Read the first two replies in this OTN forum topic.
Re: ORA-06502: PL/SQL: numeric or value error [message #382765 is a reply to message #382748] Sat, 24 January 2009 08:58 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use SQL*Plus and copy and paste your session.
Before read OraFAQ Forum Guide, especially "How to format your post?" section
and format your answer like Littlefoot did it for your question.

Regards
Michel

[Updated on: Sat, 24 January 2009 09:06]

Report message to a moderator

Previous Topic: Extract Timezone (merged)
Next Topic: Concatenation query
Goto Forum:
  


Current Time: Fri Dec 09 15:25:55 CST 2016

Total time taken to generate the page: 0.16704 seconds