You will no longer receive e-mail notifications from this forum.
Log-In to post
These people make Oracle great and have the most points for this month!
NOTE: This forum is for non-product questions and discussions on the Oracle database platform. Please post Toad-family product questions in their respective product forums. Thanks!
create or replace procedure GETINFO(P_IDS in IDS_TABLE) is --- IDS_TABLE is a table of object type conatins id1,id2,id3 cols. begin for I in 1 .. P_IDS.COUNT LOOP DBMS_OUTPUT.PUT_LINE(P_IDS(i).ID1 || ',' || P_IDS(i).ID2 || ',' || P_IDS(i).ID3); END LOOP; end GETINFO;
how to execute this procedure to get the out put?
i need one insert query in oracle but it will insert multiple row in table.
Please help me to do.
Sorry I am very new to this tool. I would need to connect to a Oracle 10.2.0.3 . What I have done so far download the sqlplus client and the relevant OCI directory all into one directory. I have set the path, ORACLE_HOME and TNS_ADMIN all to this folder where the sqlplus client . There after I tried to run my toad it say no client is found. I am not sure must is my toad the issue ? My toad say 12. 6.0.53 does this correspond to the Oracle version?
I am using Toad 22.214.171.124. When I try to create a table and import an Excel Sheet with more than 256 columns it gets cut off and the columns become non-custom. It goes back to excel letters instead of the custom names I have. Does anyone know of a work around for this?
Message from: Ed D'Agostini
Hi gurus. Can you please help me understand and fix this issue? FK's w/oMatching Indexes (or an unusable one) Regards, Ed_______________________________________Historical Messages
Author: Edson D'AgostiniDate: Tue Jan 10 16:22:56 PST 2012Hi gurus. Can you please help me understand and fix this issue? FK's w/oMatching Indexes (or an unusable one) Regards, Ed_________________________________________
Message from: curtisbl_859
I have a need to pass a subsitution parameter during a script run fromautomation designer. Is there any way to pass the &OWNER parameter to the scriptwithout being prompted?Thanks in advance.curtisbl
Author: curtisbl_859Date: Tue May 17 07:44:05 PDT 2011I have a need to pass a subsitution parameter during a script run fromautomation designer. Is there any way to pass the &OWNER parameter to the scriptwithout being prompted?Thanks in advance.curtisbl_________________________________________
I would like to install Oracle database 11g R2 (64 Bit) via TOAD on my laptop.
Request you people to guide me.
sorry if this is not the correct place to post this question but I don't see any obvious place for this post. we have oracle db2 and sql server databases and are looking for a single product where we can see all and create tables and stored procedures. does toad provide this functionality?
Can you please help me with the XML input to oracle stored procedure.I can able to use the XML inside stored procedure but I don't know I can pass in stored procedure call ?
Greetings to all
I have following query, which is working perfectly fine.
But I am trying to calculate the weekly sales( week1 and week2 from below query) using analytical functions.
SELECT inventory_item_id, ship_from_org_id, SUM (ordered_quantity), MAX (header_id), MAX (line_id), SUM (CASE WHEN no_of_days >= 0 AND no_of_days < 7 THEN ordered_quantity ELSE 0 END) week1, SUM (CASE WHEN no_of_days >= 7 AND no_of_days < 14 THEN ordered_quantity ELSE 0 END) week2FROM (SELECT a.inventory_item_id, a.ship_from_org_id, ordered_quantity, TRUNC (SYSDATE, 'day') - TRUNC (b.ordered_date) no_of_days, a.header_id, a.line_id FROM oe_order_lines_all a, oe_order_headers_all b, mtl_system_items_b c WHERE 1 = 1 AND a.inventory_item_id = c.inventory_item_id AND a.ship_from_org_id = c.organization_id AND b.booked_flag = 'Y' AND b.booked_date IS NOT NULL AND a.header_id = b.header_id and (c.organization_id = :xn_org_id or :xn_org_id is null) and (c.inventory_item_id = :xn_inventory_item_id or :xn_inventory_item_id is null))GROUP BY inventory_item_id, ship_from_org_id;
Is there any equivalent function available, how can I do it.
Thanks in advance
i am writing a plsql bubble sorting program but it is giving a error "ORA-06532: Subscript outside of limit" kindly help me to resolve it as i am new to plsqlDECLARE
temp int;type first is VARRAY(6) of integer;arr first;i integer;j integer;BEGINi:=0;j:=1;temp:=0;arr:=first(3,1,4,2,5,9);FOR i in 0..4 LOOP FOR j in 1..5 LOOP if arr(i)>arr(j) then temp:=arr(i); arr(i):=arr(j); arr(j):=temp; end if; END LOOP;END LOOP;FOR i in 0..5 LOOP dbms_output.put_line(arr(i));END LOOP;
I'v encountered a problem, possibly a bug in Toad, when package specification has a procedure with optional array parameter and I close the package by typing its name after 'END'.
CREATE OR REPLACE PACKAGE test_cast ASTYPE t_arr IS TABLE OF NUMBER INDEX BY VARCHAR2 (1);PROCEDURE proc1 (p_arr IN t_arr DEFAULT CAST (NULL AS t_arr));END;
This does not work:
CREATE OR REPLACE PACKAGE test_cast ASTYPE t_arr IS TABLE OF NUMBERINDEX BY VARCHAR2 (1);PROCEDURE proc1 (p_arr IN t_arr DEFAULT CAST (NULL AS t_arr));END test_cast;
When compiling with SQL*Plus, it works, of course.
My Toad for Oracle version: 126.96.36.199 Base Edition.
Thanks for any comments or de-bug :)
I am trying to write an sql script in toad for oracle version 9.5 that when run will allow the user to select data from a txt file from the server where the parameters / variables are entered.
The version of oracle is 10g
select employee name from employees where employee-name in "C:\names.txt"
I am trying to write an sql script in toad for oracle version 9.5 that when run will allow the user to select data from a txt file from the c drive where the parameters / variables are entered.