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)));

Did you know?Explore Trending and Topic pages for more stories like this.
The daysback is integer parameter

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

Please help
No comments posted yet

Your Answer:

Login to answer
96 Like 25 Dislike
Previous forums Next forums
Other forums

Email "$"
Hello!!

Any PHP guy with a bit of a knowledge in Flash ?

When I send a JPEG from flash

count only commas outside parenteses
I have a sql table containing
id - query - query name
the first page contains a drop down men

Linking with Foreign Keys
I have been getting an erro when I try and link:

create table Faculty_Specialty (I_Name v

XML Grouping
I'm using xml_parse_into_struct to get all my elements, but now I need to group them. For example, h

Guixt issue
Hello all,

We are experiencing the following problem with Guixt:

Some transact

help me fix these syntax errors...
I keep getting multiple syntax errors on this script like this one:

Parse error: syntax error

Probably a simple error...
I'm getting the error -- Parse error: syntax error, unexpected '{' in /home/content/c/s/t/csteffen24

urldecode question
How would I format this line of code properly?

<?php echo urldecode($_GET['Title']); ?

Best way to cross matching large datasets
Hi,

Im running a script where am I cross matching about 200 000 data sets with each other. Ea

array_combine() trouble w/csv file
I have a problem with a piece of code I wrote to import some records from a csv file into mysql. I h

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash