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

No comments posted yet

Your Answer:

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

Login Control?!
I have a Web Site that uses the login control also I have set the destinationurl to the page I want

background color imagefill
Hello

I would like to ask you why I see this square in red color just in my local xampp insta

Adding to an Int row in db
Hi, i have a database which houses all of the users of my site. One of the columns is for points whi

Warning message
I've put a website that I was doing live and I'm getting this warning message when I try to add a ne

Making multiple rows with one query
I have a table called efed_handler_characters with two fields handler_id and bio_id. What query 2 is

AJAX form submit
I recently built a form that submits data to my database with an ajax function that is called throug

Looping Problem
I've got a client that has a database with about 200 events at any given time. I'm trying to loop t

Multi language - seo links
Im trying to figure out the best method to have a multi language website that will function with seo

Deleted Delivery but material wont return
We deleted a delivery but the material its still pending.

We made a reverse goods movemen

string to currency format
Hi guys...

Actually I chunk out some data from txtfile and one of the data contains amount va

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