Home » Developer & Programmer » Precompilers, OCI & OCCI » I'm getting this error message "ORA-01722: invalid number~Error in opening c_fetch_groups CURSOR" wh
I'm getting this error message "ORA-01722: invalid number~Error in opening c_fetch_groups CURSOR" wh [message #94126] Thu, 18 March 2004 16:51 Go to next message
Mark Tecson
Messages: 3
Registered: March 2004
Junior Member
I'm a newbie to this and been getting this error message ORA-"01722: invalid number~Error in opening c_fetch_groups CURSOR"

the embedded sql statement is this:

EXEC SQL DECLARE c_fetch_groups CURSOR FOR
      SELECT ogu.change_cd,
             ogu.create_datetime,
             ogu.processed_flg,
             ogu.group_no,
             ogu.division,
             NVL(g.group_name, LPAD(' ',25)),
             NVL(g.division, LPAD(' ',25))
   FROM od_groups_updates ogu,
        groups g
   WHERE ogu.group_no = g.group_no (+)
      AND ogu.processed_flg = 'N'
      AND ogu.create_datetime < TO_DATE(:ps_datetime_stamp, 'YYYYMMDDHH24:MI:SS')        
   ORDER BY ogu.group_no, ogu.create_datetime DESC;
Re: I'm getting this error message "ORA-01722: invalid number~Error in opening c_fetch_groups CURSOR [message #94138 is a reply to message #94126] Mon, 29 March 2004 02:05 Go to previous message
Ravi
Messages: 251
Registered: June 1998
Senior Member
Hi,
May be your second last line is creating the problem.
i.e.
AND ogu.create_datetime < TO_DATE(:ps_datetime_stamp, 'YYYYMMDDHH24:MI:SS')
this may be date format problem.
I don't think any other problem.

Thanks
Ravi
Previous Topic: Passing Boolean value to oracle function thro proc
Next Topic: Simple One
Goto Forum:
  


Current Time: Mon Mar 04 22:17:56 CST 2024