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
Hi I am try to run apex locally on my computer. I already do this for oracle 11 g. I am configuring the embedded PL/SQL gateway for this purpose. but when i trying to execute this command : EXEC DBMS_XDB.SETHTTPPORT(8080); results in : OR...
2 Forum: SQL & PL/SQL «» Posted on: Fri, 19 February 2016 06:54 «» By: pointers
quoting string in multiple lines
Hi, I would like to assign a query to a bind variable using query string. Query spawn across multiple rows (100s of lines having union all satements). The below sample code works alright from a script file variable c clob; exec :c:= q'[select *...
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
Hi Tech Gurus, I have one requirement in which i have to fetch the select query from a table which i'll use to generate a report using pl/sql stored procedure. i tried doing it using ref cursor as follows:( please note that the below code is just a sampl...
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
As Michel suggested you could do it in PL/SQL. For example, SQL> set serveroutput on SQL> begin 2 execute immediate 'create table t(a number)'; 3 dbms_output.put_line('Table T created'); 4 exception 5 when others t...
5 Forum: SQL & PL/SQL «» Posted on: Thu, 25 December 2014 04:36 «» By: Michel Cadot
Re: ORA-01722: invalid number
I have not the same error than you: SQL> PROCEDURE INTIALIZE_SECOND(DUMMY NUMBER) 2 AS 3 -- Variable declaration 4 V_LIST VARCHAR2(100); 5 6 7 BEGIN 8 9 SELECT VALUE INTO V_LIST FROM CONFIG_PARAMS 10 WHERE NAME =...
6 Forum: SQL & PL/SQL «» Posted on: Fri, 11 July 2014 04:38 «» By: flyboy
Re: Execute immediate
Yes, reading the guidelines which BlackSwan posted and following them. Or, why do you think that your procedure throws these compilation errors for me? LINE/COL ERROR -------- ----------------------------------------------------------------- 33/1 ...
7 Forum: SQL & PL/SQL «» Posted on: Fri, 11 July 2014 03:54 «» By: flyboy
Re: Execute immediate
Maybe you should ask the one who provided you the procedure. Anyway, the error points to the possibility that you are passing the variable literal (enclosed with single quotes) instead of its content. set serveroutput on declare v_string varchar2(1...
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
Below is the statement i am using to create Materialized view. CREATE MATERIALIZED VIEW "DEMO"."IT_ORG_MV" ORGANIZATION HEAP PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 131072 NEXT 131072 ...
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.,
How to execute this procedure, where I'm passing table name as input? Create or replace procedure p1( emp_name in varchar2, table_name in varchar2, emp_id in number, o out varchar2) as begin execute immediate 'select'|| emp_name ||'into'|| o ||'from'...
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
Thanks BlackSwan. I unlocked the CTXSYS schema and connected to it and explictly granted execute on CTX_DDL to my user like this: SQL>alter user ctxsys account unlock; sql>conn ctxsys/<pwd>@<mydb> Connected. SQL>grant execu...
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
Hi Experts, I am on Oracle 11.2.0.3 on Linux and have Oracle Text installed in my database. I want to set up dbms_job schedule to optimize my oracle text indexes. So first I created a pl/sql procedure to optimize the indexes. But it is giving me ORA-900...
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
ORA-00900: 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 ...
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
Hi, I 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...
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
SQL> declare 2 fhandle utl_file.file_type; 3 cursor c7 is 4 select owner,table_name,num_rows from dba_tables 5 where owner in ('HR'); 6 --order by table_name,num_rows; 7 8 str varchar2...
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
SQL> declare fhandle utl_file.file_type; cursor c7 is select owner,table_name,num_rows from dba_tables where owner in ('HR'); --order by table_name,num_rows; str varchar2(200); ...
18 Forum: SQL & PL/SQL «» Posted on: Tue, 24 April 2012 23:32 «» By: foxtrot1213
invalid SQL statemet error with refcursor
Hi there, I am using PL/SQL Developer 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, rol...
19 Forum: SQL & PL/SQL «» Posted on: Tue, 14 February 2012 17:17 «» By: ThomasG
Re: Rename Column Issue
Problem seems to be the cbe_tnum index: SQL> alter table cbe rename column tnum to tnum_old; alter table cbe rename column tnum to tnum_old * ERROR at line 1: ORA-00900: invalid SQL statement SQL>...
20 Forum: SQL & PL/SQL «» Posted on: Tue, 14 February 2012 14:02 «» By: azeem87
Rename Column Issue
Hi, i am not able to rename a column for orginal table, once i create a new one with Create table as select i can rename the new table column, but not the original one, Any idea what's wrong i am doing here SQL*Plus: Release 11.2.0.1.0 Production...
21 Forum: Reports & Discoverer «» Posted on: Sun, 15 January 2012 10:01 «» By: Barbara Boehmer
Re: Lexical Parameter.
You can use lexical parameters, such as SQL*Plus substitution variables, in anonymous PL/SQL blocks, such as the third example that I provided previously: SCOTT@orcl_11gR2> set autoprint on SCOTT@orcl_11gR2> variable g_ref refcursor SCOTT@orcl...

Current Time: Sat Jun 15 18:18:21 CDT 2019