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

Include a php
Hello,

I'm trying to include a function that shows the recent searches.
Example I have <

JSON SORT WITH PHP
I have two products that I want to sort by say "Id:17, value: xxx" using php
The page w

Casting Decimals in Oracle
This code worked as a query in DB2, but I am not sure what the syntax is for casting decimals in Ora

Get word number x from string?
How can I use a function to loop through a string, and "have a look at" every word in the

Problem with an browser game.
Hello,i just joined that great forum and i got php prob,its kinda freaky...anyway i got browser game

Hom to make one url to open together with another url
I have a chat, which i want to be opened, as soon as the users login to the site. As it is now, when

Backflush
I am looking for a report in SAP that would give me a list of all parts that are populated with a ba

foreach iterator
Hi Guys
Does the foreach loop have an inbuilt iterator ?

form variables from database help.
Hi all,

I would like to have a form that gives you options based on the results of an mysql q

All possible combinations of Strings from table in PL/SQL
Hi,

I am trying to figure out how to build a list of all possible string combinations fro