Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator
145 Search Results Found
1 Forum: SQL & PL/SQL «» Posted on: Mon, 23 July 2018 17:06 «» By: shrinika
passing date value to the query from sql*plus
…to the query from sql*plus. It is passing the date. but not with HH:MI:SS. SQL> var a varchar2(20); SQL> var b varchar2(20); SQL> exec :a:=to_date('20180723101002','yyyymmddhh24miss'); PL/SQL procedure successfully completed. SQL&…
2 Forum: Windows «» Posted on: Tue, 17 October 2017 03:00 «» By: OraFerro
ODP.net passing grid data to SP UDT parameter - C#
…why doesn't Oracle UDT work the same way as passing other parameter types? Is there another type (other than OracleUDT can be used to pass datatable type as an Oracle UDT)?: public class EmployeeInfo : INullable, IOracleCustomType { …
3 Forum: SQL & PL/SQL «» Posted on: Mon, 16 October 2017 05:16 «» By: OraFerro
Passing UDT as a SP parameter
…All, In my following example I use a cursor to get data from an SQL statement and want to pass the cursor to fetch the cursor into a defined table in order to pass it to another SP which takes the table type as an input for insert. The fetch statement…
4 Forum: Server Utilities «» Posted on: Thu, 17 March 2016 17:48 «» By: Barbara Boehmer
Re: Load a CSV file into a GTT from a PL/SQL procedure
…errors. -- execution of procedure, passing file name as parameter, and results: SCOTT@orcl> exec load_data ('test.dat') PL/SQL procedure successfully completed. SCOTT@orcl> select * from gtt1 2 / C1 C2…
5 Forum: Server Utilities «» Posted on: Fri, 29 May 2015 23:46 «» By: Member2014
Bulk updates on a table for updating IDing a sequence to a table
…I put the statements in a procedure and passing the table name as a parameter. EXECUTE IMMEDIATE 'UPDATE ' || tbl_nm || ' SET id = ' || file_seq; EXECUTE IMMEDIATE 'UPDATE ' || tbl_nm || ' SET row_id = sequence.NEXTVAL'; Since its runs as a …
6 Forum: SQL & PL/SQL «» Posted on: Tue, 10 March 2015 22:36 «» By: Kevin Meade
Re: NO COPY parameters
…PL/SQL arrays, or COLLECTIONS that you were passing. You would have to make a copy of them before you pass them. If you have a 10MB array, then you have to stop and make a 10MB copy of that array before you can pass it around. If it is an IN-OUT …
7 Forum: SQL & PL/SQL «» Posted on: Fri, 26 September 2014 05:04 «» By: simplesanju
stored procedure
…:rc as refcursor; SQL>EXEC TESTING( SYS.OdciVarchar2List('A1','B1'),:RC); SQL>print :rc ID Name Sal B1 Qing 40000 Please suggest modification to get all records which I am passing through parameter. Thanks…
8 Forum: SQL & PL/SQL «» Posted on: Sun, 14 September 2014 01:48 «» By: Barbara Boehmer
Re: Need procedure to execute CLOB as paramter
…not sys ref cursor. Since you are passing numeric values in your clob without quotes between them, you need to remove the extra quotes around them in sqlquery. Your n alias is misplaced. In the example below, I have put it in the right place and …
9 Forum: SQL & PL/SQL «» Posted on: Mon, 14 July 2014 00:50 «» By: dara.naveen
Diffrent Number and type of parameter passing
…vary, how should I structure my parameter passing? In my PL/SQL procedure, should I just use have a long list (over 30) of all possible name/value pairs that might come from the WEB page or is there a more elegant way to solve this prob? Thanks &…
10 Forum: JDeveloper, Java & XML «» Posted on: Thu, 08 May 2014 03:37 «» By: sarankumar.ds
Re: Oracle XML Parsing
…calls the procedure by passing clob as parameter, which contains input xml format data. Procedure will parse the clob and insert the records into a table. for parsing dbms_xmlparser package is required, which is not available currently in my database…
11 Forum: Forms «» Posted on: Thu, 09 January 2014 11:13 «» By: mughals_king
Re: ora_ffi.find_library/load_library cannot find/open USER32.DLL
… another doc, may be useful: ORAFFI: PASSING CHARACTER STRING POINTERS BACK FROM ORA_FFI FUNCTIONS Problem Description: ==================== You need know the details on passing a character string pointer (char*) back from a function into …
12 Forum: SQL & PL/SQL «» Posted on: Mon, 07 October 2013 14:10 «» By: nataliafoster26
error
…it right now, it doesnt care is 50 its by passing it When i run this query declare TYPE SegRec IS RECORD ( DDValue VARCHAR2(50), DDDesc VARCHAR2(50) ); TYPE SegTabType IS TABLE OF SegRec; vSegData SegTabType; BEGIN SELECT Main.…
13 Forum: SQL & PL/SQL «» Posted on: Tue, 13 August 2013 23:12 «» By: sniffing
PL/SQL Open cursor Parameters
… I am running into issue when passing parameter values in open cursor. I am passing the correct parameter values but some how cursor is not returning the values for me. If i hard the same values in the cursor i get the out , not sure what i am doing here…
14 Forum: Unix «» Posted on: Mon, 22 July 2013 15:36 «» By: swapnabpnn
exception case
…report after executing pl/sql procedure by passing commandline argument SALE_LOC while running the shell script.So far it is working fine.Issue is when by mistake commandline argument is not passed it should print error as "please give sale_loc as …
15 Forum: SQL & PL/SQL «» Posted on: Mon, 20 May 2013 20:22 «» By: Barbara Boehmer
Re: utl_file error
…reading one line per loop 20 -- and passing parameter to cursor: 21 LOOP 22 BEGIN 23 UTL_FILE.GET_LINE (vInHandle, vNewLine, 32767); 24 EXCEPTION 25 WHEN NO_DATA_FOUND THEN EXIT; 26 END; 27 -- loop …
16 Forum: SQL & PL/SQL «» Posted on: Wed, 01 May 2013 19:40 «» By: xpact83
Re: sys ref cursor
…PL/SQL: cursor already open this error. but in this case of opening a cursor then passing it as a parameter in a procedure using sys_refcursor there is no such error. that's why initially i thought oracle implicitly close the cursor for me. Thanks…
17 Forum: SQL & PL/SQL «» Posted on: Fri, 08 March 2013 12:17 «» By: raghx
Passing values from Oracle Object type to PLSQL Type
…of Vaules p_in_call_request_id = 1 p_ema_resp_rec = 12345, 'Operation Failed' p_ema_lnpticket_tab = (1,2,4,5) p_endof_event = Y Kindly help to achieve this by passing Object type values to PL/SQL Type Thanks in advance, RV…
18 Forum: SQL & PL/SQL «» Posted on: Thu, 27 December 2012 16:26 «» By: gentleman777us
Passing input parameter to a like variable in procedure
…this inside a cursor within a procedure passing 'Frak Robert' value as i_name input. i.e I should be able to call the procedure as follows sql> variable v1 varchar2; sql> exec pkg_shipment.GetShipperinfo('Frank Robert',:v1); sql> print :…
19 Forum: SQL & PL/SQL «» Posted on: Tue, 28 August 2012 07:07 «» By: flyboy
Re: Package
…TO_CHAR ('satheesh', 'MM/DD/YYYY HH24:MI:SS') from dual * ERROR at line 1: ORA-01722: invalid number ? Why? As you are passing parameter with VARCHAR2 data type, so the procedure with VARCHAR2 parameter data type is invoked…
20 Forum: SQL & PL/SQL «» Posted on: Fri, 22 June 2012 12:23 «» By: rajivn786
Dynamic procedure name with record type i/p parameter
…I have a problem with passing procedure name dynamically with record type i/p parameter..I'm not attaching any insert/create table statements, as I'm unsure of forming the sql statement dynamically..Can u please correct me??? CREATE OR REPLACE …
21 Forum: Oracle Fusion Apps & E-Business Suite «» Posted on: Fri, 15 June 2012 08:53 «» By: rponmani
Is it able to pass parameters for submitting oracle alert
…through FND_REQUEST.SUBMIT_REQUEST. I am passing a value to the alert. But the request for alert ends in error. The log shows the error message as "Program was terminated by signal 11". If I submit the alert without passing parameter the …
22 Forum: SQL & PL/SQL «» Posted on: Mon, 14 May 2012 12:02 «» By: Duane
SQL Query with CASE where clause
…41 rows all the time. Problem: When passing "ut" as an SSOID parameter to the Procedure the query returns 21 rows. Taking the query and hard coding "a.sso_id like lower('ut'||'%')" the query returns 41 rows. Result: The …
23 Forum: JDeveloper, Java & XML «» Posted on: Wed, 18 April 2012 19:12 «» By: Barbara Boehmer
Re: Procedure to query an XML document
… XMLTABLE('//DATA_RECORD/*' 10 PASSING x.data_record COLUMNS 11 col_pos FOR ORDINALITY, 12 col_val VARCHAR2(200) PATH 'fn:root()', 13 col_nam VARCHAR(30) PATH 'fn:local-name(.)') 14 / COL_POS COL_NAM…
24 Forum: SQL & PL/SQL «» Posted on: Wed, 14 March 2012 18:57 «» By: Barbara Boehmer
Re: HTML code in local variable? (2 Merged)
…and how you are executing the procedure and passing the parameter to it. It also helps if you use dbms_output to display the value of the variable immediately after selecting into it. Please see the demonstration below. SCOTT@orcl_11gR2> create …
25 Forum: SQL & PL/SQL «» Posted on: Sat, 10 March 2012 18:10 «» By: rockysaggi
Run pl/sql Procedure with out passing value for IN parameter
…the procedure I don't want to pass IN parameter instead to pick the value from the package where the derivation is defined. Please help me how to run this procedure from sql prompt without passing value for IN parameter. Thanks and Regards Rocky…
26 Forum: SQL & PL/SQL «» Posted on: Wed, 01 February 2012 11:11 «» By: decci_7
SQL Injection with Dynamic SQL
…I execute the SP passing the input parameter as "MYNAME@XYZ.COM", it gives result as 1 row, as expected. DECLARE INPARAM VARCHAR2(32767); BEGIN INPARAM := 'MYNAME@XYZ.COM'; TESTNEW ( INPARAM ); END; But when I run the …
27 Forum: SQL & PL/SQL «» Posted on: Thu, 13 October 2011 14:57 «» By: Barbara Boehmer
Re: Repeat interval for DBMS_SCHEDULER
…the values to the variable before passing the variable, then just pass the variable name. SCOTT@orcl_11gR2> create table config_table 2 (value number, 3 property varchar2 (15)) 4 / Table created. SCOTT@orcl_11gR2> insert…
28 Forum: SQL & PL/SQL «» Posted on: Tue, 07 June 2011 18:53 «» By: Barbara Boehmer
Re: how to exec procedure with declare on sqlplus
… executing a procedure from SQL*Plus, passing an in parameter to the procedure, and getting output from dbms_output and 2. executing a procedure from an anonymous PL/SQL block, passing an in parameter and a variable as an out parameter, then using …
29 Forum: Application Express, ORDS & MOD_PLSQL «» Posted on: Tue, 24 May 2011 21:33 «» By: komasi75
Passing date parameter into anomynous pl/sql block in APEX
…have a report that groups 'user action' into 'action type' (ie. Add, Update, Delete) that is generated when a 'PROCESSES' which has a PL/SQL anonmynous block as it source, is kicked off. I've sinced amended the PL/SQL package, that the APEX report …
30 Forum: SQL & PL/SQL «» Posted on: Wed, 02 February 2011 04:25 «» By: cookiemonster
Re: Invalid cursor Error
…to_char(in_SPLY_REORD_NO) Why are you passing a varchar to a char? Why are you using to_char on a char? You've declared a varchar2(32767). You assign it a value. You pass it to a char parameter. This means your variable becomes a char and so …
31 Forum: SQL & PL/SQL «» Posted on: Tue, 04 January 2011 07:56 «» By: jakepolak
Passing parameter in procedure
… I have got this procedure: CREATE OR REPLACE PROCEDURE GET_NUM_ROWS(TABLE_NAME VARCHAR2) AS NUM_ROWS NUMBER; BEGIN SELECT COUNT(*) INTO NUM_ROWS FROM TABLE_NAME; DBMS_OUTPUT.PUT_LINE(NUM_ROWS); END; When I try to compile it, the …
32 Forum: SQL & PL/SQL «» Posted on: Fri, 10 December 2010 10:21 «» By: sdlasiter
Passing DATE to procedure (3 MERGED)
…struggling with this one and was hoping for input. I have a procedure that accepts a date as an input parameter. This parameter is used in a select statement to match on a table column of date type. Here's my questions: 1) Should the parameter be…
33 Forum: SQL & PL/SQL «» Posted on: Fri, 05 November 2010 15:01 «» By: rkhatiwala
# sign in proc parameter
…when i checked the parameter string it is passing only Form 4 .. I tried to '', tried "".. but it is still passing only till space after 4, i.e. Form 4 .. How to pass the whole string, Form 4 # 12 , to the procedure. Please advise. …
34 Forum: SQL & PL/SQL «» Posted on: Tue, 26 October 2010 01:41 «» By: micro_oracle
Execute Immediate problem
…have problem in executing or passing a parameter for one procedure i had created recently please support me given the following: CREATE TABLE EMPLOYEE_OT ( EMPOT_EMP_CODE VARCHAR2(6 BYTE) NOT NULL, EMPOT_PROC_MTH NUMBER(6…
35 Forum: Application Express, ORDS & MOD_PLSQL «» Posted on: Thu, 14 October 2010 04:44 «» By: Its_me_ved
Re: Invoke external stored procedure from apex
…last parameter. It works fine when I am passing at least one parameter to call the procedure. I modified the procedure 'test' with a parameter and its working fine.But what about those procedures that does not have parameters? I don't know! …
36 Forum: Precompilers, OCI & OCCI «» Posted on: Thu, 29 April 2010 15:29 «» By: aabhapandey
Passing array of structure to oracle procedure and returning back.
…created a table and some type definitions in oracle 10.2.0.3 DB as follows. There is also a procedure that I defined and is shown below. SQL> create table test_proc ( test_name varchar2(10), test_ver number (3,3), …
37 Forum: SQL & PL/SQL «» Posted on: Mon, 07 December 2009 10:16 «» By: astik.mondal
Query on PL/SQL logic
…All, I have written a procedure and passing a user name and multiple roles through parameters. Role parameter is varray type. Now we are fetching all the existing roles for the user using the below query: select role_app.role_name…
38 Forum: SQL & PL/SQL «» Posted on: Thu, 19 November 2009 13:54 «» By: harish7447
PLSQL newbie question
…or name like ('harry') So now I would be passing the Name as a string separated by commas. How can I change the pl/sql code accordingly to separate the string delimited by commas and use like or multiple times. Please help me on this. Hope I'm …
39 Forum: Weblogic & Application Server «» Posted on: Thu, 12 November 2009 01:38 «» By: vaidyanathanraja
How to increase JVM Heap Size at forms runtime
…if we run the same java class file by passing -Xmx256m parameter we are able to write to big XL file. Can anyone tell me where I am wrong... Can we increase the JVM Heap Size from forms...[EDITED by DJM: applied [code] tags and removed superfluous …
40 Forum: SQL & PL/SQL «» Posted on: Fri, 06 November 2009 03:44 «» By: aimy
PL/SQL - Passing PARAMETER as a TABLE
…akl. Here is my plan... CREATE OR REPLACE PROCEDURE P_NIS_DEL_NONMIGRATED (table_name IN varchar2, column_name IN varchar2) as cursor s1 is SELECT rowid, t.column_name from table_name t where not exists (select LOCN_TTNAME from LOCATIONS where …
Pages (4): [1  2  3  4    »]

Current Time: Sun Feb 23 18:07:51 CST 2020