Skip navigation.
Home

Site Search

Search words: "ORA-01001" Total hits: 65
Search time: 0.070 seconds Run time: 0.080 seconds

ORA-01001 Open in New Window- Rank: 1000
ORA-01001 Hello, I'm experiencing strange error: ORA-01001: Invalid cursor And this is why it is strange: PROCEDURE proc(msg IN NUMBER, details IN VARCHAR2 DEFAULT NULL) IS PRAGMA AUTONOMOUS_TRANSACTION; moduleName VARCHAR2(48); acti …
/forum/t/124610/2/ - 6682 - 2009-06-05 06:45:33 CDT -   [ Highlight ]

ORA-01001 in WHEN-VALIDATE-ITEM PLEASE HELP Open in New Window- Rank: 867
ORA-01001 in WHEN-VALIDATE-ITEM PLEASE HELP I have a WHEN-VALIDATE-ITEM trigger on one of my items. I need to have 3 conditions in the code of this trigger: a) The field can be NULL b) Since I have LOV on this item, I need to validate what the user ene …
/forum/t/29968/2/ - 3773 - 2007-05-21 01:34:33 CDT -   [ Highlight ]

ora-01001 invalid cursor Open in New Window- Rank: 798
ora-01001 invalid cursor Hi All Users, Below is the code listing for a stored procedure. I'm calling it from the trigger WHEN-VALIDATE-ITEM TO GET THE CURSOR TO FETCH DATA. IF I OPEM THE CURSOR WITH A STRING (sSqlStmt), Oracle raises the error ora-0100 …
/forum/t/142524/2/ - 2724 - 2009-03-23 04:15:09 CDT -   [ Highlight ]

ORA-01001 invalid cursor error Open in New Window- Rank: 763
ORA-01001 invalid cursor error I am getting ORa-01001 Invalid Cursor error. It used to work fine before. some changes were made to the database and platform. Do you think this will have effect? PROCEDURE post_to_treasury (payin_dt in date,records_processe …
/forum/t/29914/2/ - 3355 - 2002-11-04 03:39:13 CST -   [ Highlight ]

ora-01001 Open in New Window- Rank: 722
ora-01001 Hi all, I have created a database 10gR2 and set the open cursors to 1000. But the remote users are getting ora-01001 invalid cursor error while connecting the database from the application software(which I have not worked with). All I can thi …
/forum/t/98525/2/ - 1474 - 2008-03-07 00:12:39 CST -   [ Highlight ]

ORA-01001: invalid cursor when running dbms_tt.transprot_set_check Open in New Window- Rank: 678
… nity -> Usenet -> c.d.o.server -> ORA-01001: invalid cursor when running dbms_tt.transprot_set_check ORA-01001: invalid cursor when running dbms_tt.transprot_set_check From: Date: Fri, 08 Jun 2007 05:15:46 - …
/usenet/comp.databases.oracle.server/2007/06/08/0204.htm - 7150 - 2007-06-08 04:21:15 CDT -   [ Highlight ]

ORA-01001: invalid cursor ORA-06512 Open in New Window- Rank: 678
… nity -> Usenet -> c.d.o.server -> ORA-01001: invalid cursor ORA-06512 ORA-01001: invalid cursor ORA-06512 From: BrianK Date: 16 Jun 2006 13:49:43 -0700 Message-ID: …
/usenet/comp.databases.oracle.server/2006/06/16/1003.htm - 6549 - 2006-06-16 17:21:03 CDT -   [ Highlight ]

Re: ORA-01001: invalid cursor ORA-06512 Open in New Window- Rank: 670
… -> Usenet -> c.d.o.server -> Re: ORA-01001: invalid cursor ORA-06512 Re: ORA-01001: invalid cursor ORA-06512 From: Sybrand Bakker Date: Sat, 17 Jun 2006 00:15:15 +0200 Message-ID: …
/usenet/comp.databases.oracle.server/2006/06/16/1008.htm - 8404 - 2006-06-16 19:41:04 CDT -   [ Highlight ]

Re: ORA-01001: invalid cursor when running dbms_tt.transprot_set_check Open in New Window- Rank: 670
… -> Usenet -> c.d.o.server -> Re: ORA-01001: invalid cursor when running dbms_tt.transprot_set_check Re: ORA-01001: invalid cursor when running dbms_tt.transprot_set_check From: Date: Fri, 08 Jun 2007 05:41 …
/usenet/comp.databases.oracle.server/2007/06/08/0207.htm - 8192 - 2007-06-08 04:21:16 CDT -   [ Highlight ]

ORA-00600/00601/00604/01001 Open in New Window- Rank: 585
… error occurred at recursive SQL level 1 ORA-01001: invalid cursor ORA-00601: cleanup lock conflict Fri Aug 2 11:50:19 2002 Thread 1 advanced to log sequence 46 Current log# 3 seq# 46 mem# 0: /home/oracle/oradata/gemico/redo03.log Tue Aug 6 00:29:26 2002 Er …
/forum/t/37396/2/ - 12062 - 2004-03-17 23:01:21 CST -   [ Highlight ]

ORA-00600/00601/00604/01001 Open in New Window- Rank: 585
… error occurred at recursive SQL level 1 ORA-01001: invalid cursor ORA-00601: cleanup lock conflict Fri Aug 2 11:50:19 2002 Thread 1 advanced to log sequence 46 Current log# 3 seq# 46 mem# 0: /home/oracle/oradata/gemico/redo03.log Tue Aug 6 00:29:26 200 …
/forum/t/18863/2/ - 11824 - 2004-01-09 02:43:39 CST -   [ Highlight ]

Connecting Oracle with Centura(Error ORA-01001) Open in New Window- Rank: 585
Connecting Oracle with Centura(Error ORA-01001) I connection oracle with centura. But when I am executing any sql statement, centura raising an error Invalid cursor. If somebody solve this problem.
/forum/t/12146/2/ - 311 - 2005-01-17 18:58:35 CST -   [ Highlight ]

Create sp Open in New Window- Rank: 449
… source1'); END; * ERROR at line 1: ORA-01001: invalid cursor ORA-06512: at "SYS.DBMS_SYS_SQL", line 902 ORA-06512: at "SYS.DBMS_SQL", line 19 ORA-06512: at "TEST.AUDITINGSP", line 140 ORA-01001: invalid cursor ORA-06512: at line 1 Not sur …
/forum/t/147394/2/ - 260634 - 2009-08-21 19:55:58 CDT -   [ Highlight ]

how to check data type and length Open in New Window- Rank: 420
… NTS and USER_TAB_COLUMNS I suppose. Re:ORA-01001: invalid cursor is there any problem with the code: Declare len user_tab_columns.data_length%TYPE; con1 user_constraints.constraint_name%TYPE; col1 user_tab_columns.column_name%TYPE; tab1 user_ta …
/forum/t/75421/2/ - 9664 - 2007-01-18 01:10:04 CST -   [ Highlight ]

Invalid cursor while inserting rows Open in New Window- Rank: 299
… s, CallStack, ErrStack, ErrBackTrace); ORA-01001: invalid cursor What is more interesting: this line works for most of the time (the insert is called about 5000 times while only about 50 times exception is thrown). The code is executed from a procedure …
/forum/t/142420/2/ - 4284 - 2009-03-20 08:44:22 CDT -   [ Highlight ]