Cursor statement failed with errors

Posted on 16th Feb 2014 07:03 pm by admin

Following statement failed with the errors.

cursor proj_cursor1 is (select projectID from dsqa.table1 where projectID = any(select projectID from dsqa.table2 where enddate > (current_timestamp - daysback)));

The daysback is integer parameter

Error is :
ORA-06502: PL/SQL: numeric or value error: character to number conversion error

Please help

Your Answer:

Login to answer

Other forums

'grab_files', multiple extension?
hey guys,

can anyone suggest a way to make to following line of code look for files with more

DELETE rows based on content
I have a link in my rows

$bit="http://bit.ly/abcd";
$query = mysql_query("D

Help to integrate whois Domain Details to website
Hi,

can i know is their any php script r methods to add domain details to my website.

echo $rows help
Hi all,

Hopefully something simple that I don't know!

I have this:

Code: [Selec

Mail from PHP form not always ending up in my inbox?
Hi guys,

I'm a real newbie to PHP and have managed to put together a simple mail form that se

PDO returns erroneous columns from within pdt
Hi All,

This is a truly weird behavior:
When using a simple pdo fetch, erroneous columns a

duplicate record notification
In my database, after insertion of records, I want to know if the record inserted is duplicate or no

Converting numbers to months
The porgram works -just need the last function(month_convert_ to convert numbers to months -thanks.

need help about
i store the value of my select statement result to an array and stored it to a variable named $fname

Displaying a record from mysql in a simple swf file
Hi,

I have a mysql database containing information I would like to display in my swf.