1
  • SQLERRM = ORA-06502: PL/SQL: numeric or value error: character string buffer too small

    My procedure is shown below. When I execute it, it gives me the title error. Field3 is identified as a CLOB. Any / all help would be greatly appreciated. Running Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 CREATE OR REPLACE PROCEDURE xxx IS FileHandle SYS.UTL_FILE.FILE_TYPE; FileName...

    Bw75 pointsBadges:
  • I am getting ORA-01422: Exact fetch returns more than requested number of rows

    Hi experts, I am getting this error when I run my test case for my PL/SQL procedure, which has select and insert statements only. Not clear where I would have went wrong, Please guide me where should I check exactly. Its popping up with this error message which i caught in a exception piece after...

    Inprise610 pointsBadges:
  • Error(31,19): PLS-00103: Encountered the symbol “INTO” when expecting one of the following

    I got this error while compiling a select stm and it s my pckg body however package parameter hav OUT as well IN .. Error(31,19): PLS-00103: Encountered the symbol "INTO" when expecting one of the following: . ( , % from The symbol "from was inserted before "INTO" to continue. Anbody able to help...

    Inprise610 pointsBadges:
  • SQL error SQL0204 while using scalar function calling RPGLE program

    I've created a sclar function in SQLRPGLE which will be calling a RPGLE program for processing. There are 2 functions in the SQLRPGLE program: one for handling character field and another for processing numeric fields. Character part is working fine, but if it processes numeric part (i.e. function...

    PG30 pointsBadges:
  • Error(7,30): PLS-00103: Encountered the symbol “OUT” when expecting one of the following

    I am getting this eror when i compile my procedure with OUT Parameter ,it has got several OUT param ,but only this particular line pops up err msg Error(7,30): PLS-00103: Encountered the symbol "OUT" when expecting one of the following: := . ) , @ % default character The symbol "," was substituted...

    Inprise610 pointsBadges:
  • Oracle stored procedure error with PL/SQL

    We wrote a stored procedure, where we are passing input as VARCHAR2. And passing 73 characters string as input. Till here its fine. After giving few extra characters above this, it’s giving the error: ORA-06502: PL/SQL: numeric or value error ORA-06512: at "stored procedure name", line 114...

    BrentSheets6,925 pointsBadges:
  • PL/SQL error

    Hi Experts, I am getting the follwoing error ORA-08102: index key not found, obj# 141051, file 28, block 15245 (2) I tried rebuild on that specific obj id still error persist wat are the possible causes and how to overcome please guide me

    Inprise610 pointsBadges:
  • PL/SQL: How to check that parameter is case-sensitive?

    Hi Experts how can i check the email id shud take only lower case in PL/SQL block i tried using vpos := REGEXP_LIKE(p_email_address,'[:lower:]','C'); as well vpos ;= REGEXP_LIKE(p_email_address,'[^[:lower:]]','C') But both says wrong type as error and p_email_address is a parameter of procedure and...

    Inprise610 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following