Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator
21 Search Results Found
1 Forum: Application Express, ORDS & MOD_PLSQL «» Posted on: Tue, 10 January 2017 03:23 «» By: Rasoul_57
Error while executing EXEC DBMS_XDB.SETHTTPPORT
…in : ORA-00900: invalid SQL statement I test this code SELECT owner, object_name, object_type, created, TIMESTAMP, status FROM dba_objects WHERE object_name = 'DBMS_XDB'; results in : https://drive.google.com/…
2 Forum: SQL & PL/SQL «» Posted on: Fri, 19 February 2016 06:54 «» By: pointers
quoting string in multiple lines
…q'[select * from dual * ERROR at line 1: ORA-00900: invalid SQL statement Appending '-' at the end of the line will solve the problem but is there any alternative approach as this leads to appends 100s of line with '-' Thank you in advance …
3 Forum: SQL & PL/SQL «» Posted on: Fri, 28 August 2015 13:41 «» By: bhardkap
ora-00900 invalid sql statement while using open cursor for variable
…while executing the code i got an error ::ora-00900 invalid sql statement" . my question is :can we use v_query for fetching the rows as mentioned above ? as i can't directly hardcode the query in place of v_query as it should come from the table …
4 Forum: Client Tools «» Posted on: Sun, 26 July 2015 03:22 «» By: Lalit Kumar B
Re: Displaying Object Name after creating it in sql plus
… 8 else 9 raise; 10 end if; 11* end; SQL> / begin * ERROR at line 1: ORA-00900: invalid SQL statement ORA-06512: at line 9 SQL> Edit : Added the code to re-raise error when sqlcode other than -955…
5 Forum: SQL & PL/SQL «» Posted on: Thu, 25 December 2014 04:36 «» By: Michel Cadot
Re: ORA-01722: invalid number
… ) 25 VALUES 26 ( 27 SEQ.nextval, 28 INNER_QUERY.KEY, 29 'Y' 30 ); 31 END INTIALIZE_SECOND; 32 / PROCEDURE INTIALIZE_SECOND(DUMMY NUMBER) * ERROR at line 1: ORA-00900: invalid SQL statement…
6 Forum: SQL & PL/SQL «» Posted on: Fri, 11 July 2014 04:38 «» By: flyboy
Re: Execute immediate
…good call declare * ERROR at line 1: ORA-00900: invalid SQL statement ORA-06512: at line 5 Hint: there are more characters which look like space, e.g. the non-breaking one: http://en.wikipedia.org/wiki/Non-breaking_space [Edit: added the wiki …
7 Forum: SQL & PL/SQL «» Posted on: Fri, 11 July 2014 03:54 «» By: flyboy
Re: Execute immediate
…bad call declare * ERROR at line 1: ORA-00900: invalid SQL statement ORA-06512: at line 7 Again, as it is impossible to reproduce your problems, this is just a guess. Regarding the quotes around string literals in dynamic SQL, see my previous …
8 Forum: Server Administration «» Posted on: Fri, 06 June 2014 11:48 «» By: Jack14
Re: ORA-01652: unable to extend temp segment by 16 in tablespace DATA03
…(+) = customer.x_pip_id AND 88 init_opty.par_opty_id is null AND 89 pos.PR_EMP_ID = emp.row_id (+) 90 / pos.PR_EMP_ID = emp.row_id (+) * ERROR at line 89: ORA-00900: invalid SQL statement Thanks, Jack…
9 Forum: SQL & PL/SQL «» Posted on: Wed, 07 May 2014 06:38 «» By: cookiemonster
Re: unable truncate table in plsql block
You can't possibly have got that error from that code. PLS-00103 is a compile time error, the contents of an execute immediate statement is not checked at compile time and if it was invalid you would get ORA-00900 Invalid SQL statement when you run it.
10 Forum: SQL & PL/SQL «» Posted on: Thu, 20 February 2014 03:32 «» By: Rarawshenkiv
Procedure.,
…varchar2(50); begin p1('emp', 'Vicky',5, x); dbms_output.put_line(x); end; Error report: ORA-00900: invalid SQL statement ORA-06512: at "PORTALADMIN.P1", line 4 ORA-06512: at line 4 00900. 00000 - "invalid SQL statement"…
11 Forum: Text & interMedia «» Posted on: Mon, 30 September 2013 14:57 «» By: orausern
Re: ORA-900 invalid sql statement error while calling optimize_index procedure from pl/sql
…while optimizing the index 'ACCESS_CLNT_IDX04'-900 ORA-00900: invalid SQL statement I have now granted the privileges as CTXSYS on CTX_DDL. What else do I need to do? Please suggest, I will be most thankful for the review. Thank you…
12 Forum: Text & interMedia «» Posted on: Mon, 30 September 2013 13:47 «» By: orausern
ORA-900 invalid sql statement error while calling optimize_index procedure from pl/sql
…optimizing the index ACCESS_CLNT_IDX04 -900 ORA-00900: invalid SQL statement PL/SQL procedure successfully completed. --however if the same command if I run from sqlplus it doesn't give any error!! SQL>exec ctx_ddl.optimize_index (idx_name =>'…
13 Forum: SQL & PL/SQL «» Posted on: Wed, 11 September 2013 04:56 «» By: mist598
Re: Error: PLS-00103 in package
Thanks johanndut, Yes, remove the END after the END LOOP.It working fine, in TOAD i am getting ORA-00900: invalid SQL statement Regards, Surya
14 Forum: SQL & PL/SQL «» Posted on: Fri, 10 May 2013 08:02 «» By: Littlefoot
Re: Error in Execute Immediate
…Invalid SQL statement. Obviously, you'll have to fix it so that it becomes valid. As you use dynamic SQL, create a local variable, put the whole statement into it and display it with DBMS_OUTPUT.PUT_LINE so that you'd see what you are trying to execute…
15 Forum: Server Utilities «» Posted on: Thu, 04 April 2013 06:58 «» By: asksrikanth@gmail.com
Execution of Oracle 11g wrapped procedure gives ora-00900 error
…have a procedure which i wrapped using the oracle 11g wrap utility. If i execute the wrapped procedure using jdbc i am getting an error of 0RA-00900 invalid sql statement. The procedure is having basic sql statements only. The same procedure if i …
16 Forum: SQL & PL/SQL «» Posted on: Wed, 22 August 2012 09:29 «» By: sarma.shp
Re: Sum of length of column data of all tables
… 32 dbms_output.put_line('step 3'); 33 34 dbms_output.put_line('step 4'); 35 end loop; 36 37 UTL_FILE.FCLOSE(fhandle); 38 39 end; ERROR at line 1: ORA-00900: invalid SQL statement ORA-06512: at line 25…
17 Forum: SQL & PL/SQL «» Posted on: Wed, 22 August 2012 09:08 «» By: sarma.shp
Re: Sum of length of column data of all tables
…3'); dbms_output.put_line('step 4'); end loop; UTL_FILE.FCLOSE(fhandle); end; / SQL> @"/new2.sql" declare * ERROR at line 1: ORA-00900: invalid SQL statement ORA-06512: at line 26…
18 Forum: SQL & PL/SQL «» Posted on: Tue, 24 April 2012 23:32 «» By: foxtrot1213
invalid SQL statemet error with refcursor
…and I get the following errors: ORA-00900: invalid SQL statement ORA-01008: not all variables bound ORA-00900: invalid SQL statement Tables: CREATE TABLE competence.skill_role (skill_id NUMBER, role_id NUMBER, target_value NUMBER…
19 Forum: SQL & PL/SQL «» Posted on: Tue, 14 February 2012 17:17 «» By: ThomasG
Re: Rename Column Issue
…tnum to tnum_old * ERROR at line 1: ORA-00900: invalid SQL statement SQL> drop index cbe_tnum; Index dropped. SQL> alter table cbe rename column tnum to tnum_old; Table altered. SQL>…
20 Forum: SQL & PL/SQL «» Posted on: Tue, 14 February 2012 14:02 «» By: azeem87
Rename Column Issue
… * ERROR at line 1: ORA-00900: invalid SQL statement SQL> create table cbe_test as select * from cbe; Table created. SQL> alter table cbe_test rename column tnum to tnum_old; Table altered. SQL> thanks…
21 Forum: Reports & Discoverer «» Posted on: Sun, 15 January 2012 10:01 «» By: Barbara Boehmer
Re: Lexical Parameter.
…(:g_ref); END; * ERROR at line 1: ORA-00900: invalid SQL statement ORA-06512: at "SCOTT.STORED_PROCEDURE_NAME", line 5 ORA-06512: at line 1 ERROR: ORA-24338: statement handle not executed SP2-0625: Error printing variable "…

Current Time: Wed Dec 11 19:26:51 CST 2019