Home » SQL & PL/SQL » SQL & PL/SQL » Execute Package.Function
Execute Package.Function [message #19569] Thu, 28 March 2002 13:10 Go to next message
Neil Jackson
Messages: 2
Registered: March 2002
Junior Member
Hello,

I'm still new to Oracle but somewhat familar with SQL with a competing prod. I really like the concept of Packages in Oracle and want to learn more. I want to execute a function within a package that has output parameters so I want to capture the results into a table or simply variables if possible, if someone could please review my logic/code below and provide any hints to where I'm losing it, i would greatly appreciate it. Basically I want to interface with the data directly through Oracle.

Thanks in advance
Neil

set echo off
set feedback off
set head off
set serveroutput on;

create table testOutput(
value1 varchar2(5),
value2 varchar2(10),
value3 varchar2(10),
value4 varchar2(10),
value5 varchar2(10),
value6 varchar2(10),
value7 varchar2(10),
value8 varchar2(11),
value9 varchar2(12),
value10 varchar2(13),
value11 varchar2(14),
value12 varchar2(15),
value13 varchar2(10),
value14 varchar2(10),
value15 varchar2(30));

commit;

var myID varchar2(10);
var valueOutput1 ss varchar2(10);
var valueOutput2 varchar2(10);
var valueOutput3 varchar2(50);
var valueOutput4 varchar2(10);
var valueOutput5 varchar2(100);
var valueOutput6 varchar2(10);
var valueOutput7 varchar2(20);
var valueOutput8 varchar2(10);
var valueOutput9 varchar2(10);
var valueOutput10 varchar2(10);
var valueOutput11 varchar2(10);
var valueOutput12 varchar2(10);
var valueOutput13 varchar2(10);
var valueOutput14 varchar(30);

exec :myID := '27';

execute agile_server_item.fetch_item(myID, valueOutput1, valueOutput2, valueOutput3, valueOutput4, valueOutput5, valueOutput6, valueOutput7, valueOutput8, valueOutput9, valueOutput10, valueOutput11, valueOutput12, valueOutput13, valueOutput14);

insert into testOutput(value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11, value12, value13, value14, value15)
values(myID, valueOutput1, valueOutput2, valueOutput3, valueOutput4, valueOutput5, valueOutput6, valueOutput7, valueOutput8, valueOutput9, valueOutput10, valueOutput11, valueOutput12, valueOutput13, valueOutput14);

select * from testOutput;

drop table testOutput;

Report message to a moderator

Re: Execute Package.Function [message #19571 is a reply to message #19569] Thu, 28 March 2002 13:25 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Neil, since you don't refer to a specific problem, can you provide some more information about what is not working? Also, we might need to see what is happening in your function.

Report message to a moderator

Previous Topic: Select Variable
Next Topic: Using a field with low cardinality in a where clause.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 22:25:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.