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

Creation of Raw Exposure manually
SAP Gurus

I am creating Raw Exposure ( Hedge management ) thru T Code TEM10 with followin

Update data to upper case in parent/child tables
Hi Gurus!

In production we have a product table and which is being reference by many tabl

getting most records by count
Code: [Select]<?php

$connect = mysql_connect("localhost","dam

php call servlet
I have done a php backup application .
So there is a form that user pick some files to zip and d

Is there something wrong?
Hi all,

Just a quick question... can someone look at this code and see if something is wrong?

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

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

Logging and nologging bulk insert
Hi,

oracle version: 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

Sales orders ans reservations not taken into account on MPS / MRP
Hello,

I am implementing the MPS / MRP and I have the following problem:

I ha

Function module "DPS_CHECK_TABLE_EXISTS" not found (after OSS 1422843 impl)
Dear All,

I implemented Note OSS 1422843.

When i execute the new report RSPO20