Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Problem with calling Oracle7.3.4 Stored Procs.

4 posts in PB Infomaker Report Writer Last posting was on 1999-06-22 17:21:01.0Z
LarryB Posted on 1999-06-21 18:32:20.0Z
Newsgroups: sybase.public.infomaker.general
From: "LarryB" <lhb1@mindspring.com>
Subject: Problem with calling Oracle7.3.4 Stored Procs.
Date: Mon, 21 Jun 1999 14:32:20 -0400
Lines: 126
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_ApvUlOBv#GA.205@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6188
Article PK: 240124

When I run a report that calls a stored procedure I get the following
message.

Select error: ORA-06550: line 1, column 16
PLS-00306: wrong number or types of arguments in call to
'GET_PAGE_INSTRUCTIONS'
ORA-06550: line 1, column 16
PL/SQL: Statement ignored.

I've gotten this before but it was always a problem with a wrong data type
being passed.
I have checked again and again but they seem OK.
I even took out all arguments from both IM and Oracle and still same
message.

1. Do I have to pass the IN OUT argument (the result set)?
2. How would I do that anyway as it is a record type?
3. What exactly is the format for the "Edit Execute" Box.


Below is the way the stored procedure is set up.
Any help would be greatly appreciated.

----------------------------------------------------------------------------
-----------
package FSR_STORED_PROCS is

type instructions is record ( page_inst1 varchar2 (2000),
page_inst varchar2 (2000), page_inst3 varchar2 (2000));

type inst_cursor is ref cursor return instructions;

procedure get_page_instructions (notebook_id IN VARCHAR2,
notebook_rev IN VARCHAR2,
procpt_seq IN NUMBER,
page_seq IN NUMBER,
full_instr IN OUT inst_cursor );
----------------------------------------------------------------------------
-------
procedure get_page_instructions
(notebook_id IN VARCHAR2,
notebook_rev IN VARCHAR2,
procpt_seq IN NUMBER,
page_seq IN NUMBER,
full_instr IN OUT fsr_stored_procs.inst_cursor
)
AS
maxlen CONSTANT NUMBER(4) := 2000;
row_len CONSTANT NUMBER(3) := 256;
inst1 VARCHAR2 (2000) := ' ';
inst2 VARCHAR2 (2000) := ' ';
inst3 VARCHAR2 (2000) := ' ';
db_tabchar VARCHAR2(1) := CHR(9) ;
tabchar VARCHAR2(20) := ' ';
db_leadspaces VARCHAR2(2) := CHR(10) || ' ';
leadspaces VARCHAR2(2) := CHR(10) || '.';
db_openline VARCHAR2(2) := CHR(10) || CHR(10);
openline VARCHAR2(3) := CHR(10) || '.' || CHR(10);
db_row NUMBER(3) := 0;
set_num NUMBER(3);
maxlines NUMBER(3);
CURSOR instructions_cursor
(parm_notebook_id VARCHAR2,
parm_notebook_rev VARCHAR2,
parm_procpt_seq NUMBER,
parm_page_seq NUMBER
)
IS
SELECT ops$fsmgr.nb_page_inst.instructions
FROM ops$fsmgr.nb_page_inst
WHERE ops$fsmgr.nb_page_inst.notebook_id = parm_notebook_id
AND ops$fsmgr.nb_page_inst.notebook_rev = parm_notebook_rev
AND ops$fsmgr.nb_page_inst.procpt_seq = parm_procpt_seq
AND ops$fsmgr.nb_page_inst.page_seq = parm_page_seq
ORDER BY inst_seq;
BEGIN
maxlines := maxlen / row_len;
FOR instruction_line IN instructions_cursor (notebook_id, notebook_rev,
procpt_seq, page_seq) LOOP
db_row := db_row + 1;
set_num := db_row / (maxlines + 1);
IF set_num = 0 THEN
inst1 := inst1 || instruction_line.instructions;
ELSIF set_num = 1 THEN
inst2 := inst2 || instruction_line.instructions;
ELSIF set_num = 2 THEN
inst3 := inst3 || instruction_line.instructions;
END IF;
END LOOP;
inst1 := REPLACE(REPLACE(REPLACE(inst1, db_tabchar, tabchar),
db_leadspaces, leadspaces), db_openline, openline) ;
inst2 := REPLACE(REPLACE(REPLACE(inst2, db_tabchar, tabchar),
db_leadspaces, leadspaces), db_openline, openline) ;
inst3 := REPLACE(REPLACE(REPLACE(inst3, db_tabchar, tabchar),
db_leadspaces, leadspaces), db_openline, openline) ;
OPEN full_instr FOR
SELECT inst1, inst2, inst3
FROM dual
WHERE rownum = 1;
END get_page_instructions;

---------------- END OF ORCLE STUFF ------- START OF IM STUFF ----
Result Set: 1

compute_001 String 2000
compute_002 String 2000
compute_003 String 2000

Arguments:

NOTEBOOK_ID String
NOTEBOOK_REV String
PROCPT_SEQ Number
PAGE_SEQ Number


Edit Execute Box:

execute FSRDBA.GET_PAGE_INSTRUCTIONS;0 NOTEBOOK_ID =
:NOTEBOOK_ID,NOTEBOOK_REV = :NOTEBOOK_REV, PROCPT_SEQ = :PROCPT_SEQ,
PAGE_SEQ = :PAGE_SEQ

EOF


LarryB Posted on 1999-06-22 14:00:32.0Z
Newsgroups: sybase.public.infomaker.general
From: "LarryB" <lhb1@mindspring.com>
Subject: Re: Problem with calling Oracle7.3.4 Stored Procs.
Date: Tue, 22 Jun 1999 10:00:32 -0400
Lines: 136
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_UHSCQbLv#GA.291@forums.sybase.com>
References: <348_ApvUlOBv#GA.205@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6184
Article PK: 240119

Forgot to mention that I'm running IM 6.5.
I just recently upgraded from Oracle 7.3.3 and from IM6.0

-LarryB

LarryB wrote in message ...
>When I run a report that calls a stored procedure I get the following
>message.
>
> Select error: ORA-06550: line 1, column 16
> PLS-00306: wrong number or types of arguments in call to
>'GET_PAGE_INSTRUCTIONS'
> ORA-06550: line 1, column 16
> PL/SQL: Statement ignored.
>
>I've gotten this before but it was always a problem with a wrong data type
>being passed.
>I have checked again and again but they seem OK.
>I even took out all arguments from both IM and Oracle and still same
>message.
>
>1. Do I have to pass the IN OUT argument (the result set)?
>2. How would I do that anyway as it is a record type?
>3. What exactly is the format for the "Edit Execute" Box.
>
>
>Below is the way the stored procedure is set up.
>Any help would be greatly appreciated.
>
>---------------------------------------------------------------------------
-
>-----------
>package FSR_STORED_PROCS is
>
> type instructions is record ( page_inst1 varchar2 (2000),
> page_inst varchar2 (2000), page_inst3 varchar2 (2000));
>
> type inst_cursor is ref cursor return instructions;
>
> procedure get_page_instructions (notebook_id IN VARCHAR2,
> notebook_rev IN VARCHAR2,
> procpt_seq IN NUMBER,
> page_seq IN NUMBER,
> full_instr IN OUT inst_cursor );
>---------------------------------------------------------------------------
-
>-------
>procedure get_page_instructions
>(notebook_id IN VARCHAR2,
> notebook_rev IN VARCHAR2,
> procpt_seq IN NUMBER,
> page_seq IN NUMBER,
> full_instr IN OUT fsr_stored_procs.inst_cursor
>)
>AS
>maxlen CONSTANT NUMBER(4) := 2000;
>row_len CONSTANT NUMBER(3) := 256;
>inst1 VARCHAR2 (2000) := ' ';
>inst2 VARCHAR2 (2000) := ' ';
>inst3 VARCHAR2 (2000) := ' ';
>db_tabchar VARCHAR2(1) := CHR(9) ;
>tabchar VARCHAR2(20) := ' ';
>db_leadspaces VARCHAR2(2) := CHR(10) || ' ';
>leadspaces VARCHAR2(2) := CHR(10) || '.';
>db_openline VARCHAR2(2) := CHR(10) || CHR(10);
>openline VARCHAR2(3) := CHR(10) || '.' || CHR(10);
>db_row NUMBER(3) := 0;
>set_num NUMBER(3);
>maxlines NUMBER(3);
>CURSOR instructions_cursor
> (parm_notebook_id VARCHAR2,
> parm_notebook_rev VARCHAR2,
> parm_procpt_seq NUMBER,
> parm_page_seq NUMBER
> )
> IS
> SELECT ops$fsmgr.nb_page_inst.instructions
> FROM ops$fsmgr.nb_page_inst
> WHERE ops$fsmgr.nb_page_inst.notebook_id = parm_notebook_id
> AND ops$fsmgr.nb_page_inst.notebook_rev = parm_notebook_rev
> AND ops$fsmgr.nb_page_inst.procpt_seq = parm_procpt_seq
> AND ops$fsmgr.nb_page_inst.page_seq = parm_page_seq
> ORDER BY inst_seq;
>BEGIN
> maxlines := maxlen / row_len;
> FOR instruction_line IN instructions_cursor (notebook_id, notebook_rev,
>procpt_seq, page_seq) LOOP
> db_row := db_row + 1;
> set_num := db_row / (maxlines + 1);
> IF set_num = 0 THEN
> inst1 := inst1 || instruction_line.instructions;
> ELSIF set_num = 1 THEN
> inst2 := inst2 || instruction_line.instructions;
> ELSIF set_num = 2 THEN
> inst3 := inst3 || instruction_line.instructions;
> END IF;
> END LOOP;
> inst1 := REPLACE(REPLACE(REPLACE(inst1, db_tabchar, tabchar),
>db_leadspaces, leadspaces), db_openline, openline) ;
> inst2 := REPLACE(REPLACE(REPLACE(inst2, db_tabchar, tabchar),
>db_leadspaces, leadspaces), db_openline, openline) ;
> inst3 := REPLACE(REPLACE(REPLACE(inst3, db_tabchar, tabchar),
>db_leadspaces, leadspaces), db_openline, openline) ;
> OPEN full_instr FOR
> SELECT inst1, inst2, inst3
> FROM dual
> WHERE rownum = 1;
>END get_page_instructions;
>
>---------------- END OF ORCLE STUFF ------- START OF IM STUFF ----
>Result Set: 1
>
>compute_001 String 2000
>compute_002 String 2000
>compute_003 String 2000
>
>Arguments:
>
>NOTEBOOK_ID String
>NOTEBOOK_REV String
>PROCPT_SEQ Number
>PAGE_SEQ Number
>
>
>Edit Execute Box:
>
>execute FSRDBA.GET_PAGE_INSTRUCTIONS;0 NOTEBOOK_ID =
>:NOTEBOOK_ID,NOTEBOOK_REV = :NOTEBOOK_REV, PROCPT_SEQ = :PROCPT_SEQ,
>PAGE_SEQ = :PAGE_SEQ
>
>EOF
>
>
>


Terry Dykstra Posted on 1999-06-22 15:05:02.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Problem with calling Oracle7.3.4 Stored Procs.
Date: Tue, 22 Jun 1999 09:05:02 -0600
Lines: 229
X-Newsreader: Microsoft Outlook Express 4.72.3612.1700
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
Message-ID: <348_mNaAg$Lv#GA.267@forums.sybase.com>
References: <348_ApvUlOBv#GA.205@forums.sybase.com> <348_UHSCQbLv#GA.291@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6182
Article PK: 240118

I've included an example script. Hopefully that helps.

--
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.

LarryB wrote in message ...
>Forgot to mention that I'm running IM 6.5.
>I just recently upgraded from Oracle 7.3.3 and from IM6.0
>
>-LarryB
>
>LarryB wrote in message ...
>>When I run a report that calls a stored procedure I get the following
>>message.
>>
>> Select error: ORA-06550: line 1, column 16
>> PLS-00306: wrong number or types of arguments in call to
>>'GET_PAGE_INSTRUCTIONS'
>> ORA-06550: line 1, column 16
>> PL/SQL: Statement ignored.
>>
>>I've gotten this before but it was always a problem with a wrong data
type
>>being passed.
>>I have checked again and again but they seem OK.
>>I even took out all arguments from both IM and Oracle and still same
>>message.
>>
>>1. Do I have to pass the IN OUT argument (the result set)?
>>2. How would I do that anyway as it is a record type?
>>3. What exactly is the format for the "Edit Execute" Box.
>>
>>
>>Below is the way the stored procedure is set up.
>>Any help would be greatly appreciated.
>>
>>--------------------------------------------------------------------------
-
>-
>>-----------
>>package FSR_STORED_PROCS is
>>
>> type instructions is record ( page_inst1 varchar2 (2000),
>> page_inst varchar2 (2000), page_inst3 varchar2 (2000));
>>
>> type inst_cursor is ref cursor return instructions;
>>
>> procedure get_page_instructions (notebook_id IN VARCHAR2,
>> notebook_rev IN VARCHAR2,
>> procpt_seq IN NUMBER,
>> page_seq IN NUMBER,
>> full_instr IN OUT inst_cursor );
>>--------------------------------------------------------------------------
-
>-
>>-------
>>procedure get_page_instructions
>>(notebook_id IN VARCHAR2,
>> notebook_rev IN VARCHAR2,
>> procpt_seq IN NUMBER,
>> page_seq IN NUMBER,
>> full_instr IN OUT fsr_stored_procs.inst_cursor
>>)
>>AS
>>maxlen CONSTANT NUMBER(4) := 2000;
>>row_len CONSTANT NUMBER(3) := 256;
>>inst1 VARCHAR2 (2000) := ' ';
>>inst2 VARCHAR2 (2000) := ' ';
>>inst3 VARCHAR2 (2000) := ' ';
>>db_tabchar VARCHAR2(1) := CHR(9) ;
>>tabchar VARCHAR2(20) := ' ';
>>db_leadspaces VARCHAR2(2) := CHR(10) || ' ';
>>leadspaces VARCHAR2(2) := CHR(10) || '.';
>>db_openline VARCHAR2(2) := CHR(10) || CHR(10);
>>openline VARCHAR2(3) := CHR(10) || '.' || CHR(10);
>>db_row NUMBER(3) := 0;
>>set_num NUMBER(3);
>>maxlines NUMBER(3);
>>CURSOR instructions_cursor
>> (parm_notebook_id VARCHAR2,
>> parm_notebook_rev VARCHAR2,
>> parm_procpt_seq NUMBER,
>> parm_page_seq NUMBER
>> )
>> IS
>> SELECT ops$fsmgr.nb_page_inst.instructions
>> FROM ops$fsmgr.nb_page_inst
>> WHERE ops$fsmgr.nb_page_inst.notebook_id = parm_notebook_id
>> AND ops$fsmgr.nb_page_inst.notebook_rev = parm_notebook_rev
>> AND ops$fsmgr.nb_page_inst.procpt_seq = parm_procpt_seq
>> AND ops$fsmgr.nb_page_inst.page_seq = parm_page_seq
>> ORDER BY inst_seq;
>>BEGIN
>> maxlines := maxlen / row_len;
>> FOR instruction_line IN instructions_cursor (notebook_id,
notebook_rev,
>>procpt_seq, page_seq) LOOP
>> db_row := db_row + 1;
>> set_num := db_row / (maxlines + 1);
>> IF set_num = 0 THEN
>> inst1 := inst1 || instruction_line.instructions;
>> ELSIF set_num = 1 THEN
>> inst2 := inst2 || instruction_line.instructions;
>> ELSIF set_num = 2 THEN
>> inst3 := inst3 || instruction_line.instructions;
>> END IF;
>> END LOOP;
>> inst1 := REPLACE(REPLACE(REPLACE(inst1, db_tabchar, tabchar),
>>db_leadspaces, leadspaces), db_openline, openline) ;
>> inst2 := REPLACE(REPLACE(REPLACE(inst2, db_tabchar, tabchar),
>>db_leadspaces, leadspaces), db_openline, openline) ;
>> inst3 := REPLACE(REPLACE(REPLACE(inst3, db_tabchar, tabchar),
>>db_leadspaces, leadspaces), db_openline, openline) ;
>> OPEN full_instr FOR
>> SELECT inst1, inst2, inst3
>> FROM dual
>> WHERE rownum = 1;
>>END get_page_instructions;
>>
>>---------------- END OF ORCLE STUFF ------- START OF IM STUFF ----
>>Result Set: 1
>>
>>compute_001 String 2000
>>compute_002 String 2000
>>compute_003 String 2000
>>
>>Arguments:
>>
>>NOTEBOOK_ID String
>>NOTEBOOK_REV String
>>PROCPT_SEQ Number
>>PAGE_SEQ Number
>>
>>
>>Edit Execute Box:
>>
>>execute FSRDBA.GET_PAGE_INSTRUCTIONS;0 NOTEBOOK_ID =
>>:NOTEBOOK_ID,NOTEBOOK_REV = :NOTEBOOK_REV, PROCPT_SEQ = :PROCPT_SEQ,
>>PAGE_SEQ = :PAGE_SEQ
>>
>>EOF
>>
>>
>>
>
>


LarryB Posted on 1999-06-22 17:21:01.0Z
Newsgroups: sybase.public.infomaker.general
From: "LarryB" <lhb1@mindspring.com>
Subject: Re: Problem with calling Oracle7.3.4 Stored Procs.
Date: Tue, 22 Jun 1999 13:21:01 -0400
Lines: 165
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_sN80VLNv#GA.206@forums.sybase.com>
References: <348_ApvUlOBv#GA.205@forums.sybase.com> <348_UHSCQbLv#GA.291@forums.sybase.com> <348_mNaAg$Lv#GA.267@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6176
Article PK: 240113

Terry;

It all came down to the PBDBMS being wrong (set) in the DB profile. This
probably got set either during the IM upgrade or Oracle upg.
Your sql also helped simplify the understanding of what goes on during a SP
call.

Thanx again.

-LarryB

Terry Dykstra wrote in message ...
>I've included an example script. Hopefully that helps.
>
>--
>Terry Dykstra (TeamSybase)
>Canadian Forest Oil Ltd.
>LarryB wrote in message ...
>>Forgot to mention that I'm running IM 6.5.
>>I just recently upgraded from Oracle 7.3.3 and from IM6.0
>>
>>-LarryB
>>
>>LarryB wrote in message ...
>>>When I run a report that calls a stored procedure I get the following
>>>message.
>>>
>>> Select error: ORA-06550: line 1, column 16
>>> PLS-00306: wrong number or types of arguments in call to
>>>'GET_PAGE_INSTRUCTIONS'
>>> ORA-06550: line 1, column 16
>>> PL/SQL: Statement ignored.
>>>
>>>I've gotten this before but it was always a problem with a wrong data
>type
>>>being passed.
>>>I have checked again and again but they seem OK.
>>>I even took out all arguments from both IM and Oracle and still same
>>>message.
>>>
>>>1. Do I have to pass the IN OUT argument (the result set)?
>>>2. How would I do that anyway as it is a record type?
>>>3. What exactly is the format for the "Edit Execute" Box.
>>>
>>>
>>>Below is the way the stored procedure is set up.
>>>Any help would be greatly appreciated.
>>>
>>>-------------------------------------------------------------------------
-
>-
>>-
>>>-----------
>>>package FSR_STORED_PROCS is
>>>
>>> type instructions is record ( page_inst1 varchar2 (2000),
>>> page_inst varchar2 (2000), page_inst3 varchar2 (2000));
>>>
>>> type inst_cursor is ref cursor return instructions;
>>>
>>> procedure get_page_instructions (notebook_id IN VARCHAR2,
>>> notebook_rev IN VARCHAR2,
>>> procpt_seq IN NUMBER,
>>> page_seq IN NUMBER,
>>> full_instr IN OUT inst_cursor );
>>>-------------------------------------------------------------------------
-
>-
>>-
>>>-------
>>>procedure get_page_instructions
>>>(notebook_id IN VARCHAR2,
>>> notebook_rev IN VARCHAR2,
>>> procpt_seq IN NUMBER,
>>> page_seq IN NUMBER,
>>> full_instr IN OUT fsr_stored_procs.inst_cursor
>>>)
>>>AS
>>>maxlen CONSTANT NUMBER(4) := 2000;
>>>row_len CONSTANT NUMBER(3) := 256;
>>>inst1 VARCHAR2 (2000) := ' ';
>>>inst2 VARCHAR2 (2000) := ' ';
>>>inst3 VARCHAR2 (2000) := ' ';
>>>db_tabchar VARCHAR2(1) := CHR(9) ;
>>>tabchar VARCHAR2(20) := ' ';
>>>db_leadspaces VARCHAR2(2) := CHR(10) || ' ';
>>>leadspaces VARCHAR2(2) := CHR(10) || '.';
>>>db_openline VARCHAR2(2) := CHR(10) || CHR(10);
>>>openline VARCHAR2(3) := CHR(10) || '.' || CHR(10);
>>>db_row NUMBER(3) := 0;
>>>set_num NUMBER(3);
>>>maxlines NUMBER(3);
>>>CURSOR instructions_cursor
>>> (parm_notebook_id VARCHAR2,
>>> parm_notebook_rev VARCHAR2,
>>> parm_procpt_seq NUMBER,
>>> parm_page_seq NUMBER
>>> )
>>> IS
>>> SELECT ops$fsmgr.nb_page_inst.instructions
>>> FROM ops$fsmgr.nb_page_inst
>>> WHERE ops$fsmgr.nb_page_inst.notebook_id = parm_notebook_id
>>> AND ops$fsmgr.nb_page_inst.notebook_rev = parm_notebook_rev
>>> AND ops$fsmgr.nb_page_inst.procpt_seq = parm_procpt_seq
>>> AND ops$fsmgr.nb_page_inst.page_seq = parm_page_seq
>>> ORDER BY inst_seq;
>>>BEGIN
>>> maxlines := maxlen / row_len;
>>> FOR instruction_line IN instructions_cursor (notebook_id,
>notebook_rev,
>>>procpt_seq, page_seq) LOOP
>>> db_row := db_row + 1;
>>> set_num := db_row / (maxlines + 1);
>>> IF set_num = 0 THEN
>>> inst1 := inst1 || instruction_line.instructions;
>>> ELSIF set_num = 1 THEN
>>> inst2 := inst2 || instruction_line.instructions;
>>> ELSIF set_num = 2 THEN
>>> inst3 := inst3 || instruction_line.instructions;
>>> END IF;
>>> END LOOP;
>>> inst1 := REPLACE(REPLACE(REPLACE(inst1, db_tabchar, tabchar),
>>>db_leadspaces, leadspaces), db_openline, openline) ;
>>> inst2 := REPLACE(REPLACE(REPLACE(inst2, db_tabchar, tabchar),
>>>db_leadspaces, leadspaces), db_openline, openline) ;
>>> inst3 := REPLACE(REPLACE(REPLACE(inst3, db_tabchar, tabchar),
>>>db_leadspaces, leadspaces), db_openline, openline) ;
>>> OPEN full_instr FOR
>>> SELECT inst1, inst2, inst3
>>> FROM dual
>>> WHERE rownum = 1;
>>>END get_page_instructions;
>>>
>>>---------------- END OF ORCLE STUFF ------- START OF IM STUFF ----
>>>Result Set: 1
>>>
>>>compute_001 String 2000
>>>compute_002 String 2000
>>>compute_003 String 2000
>>>
>>>Arguments:
>>>
>>>NOTEBOOK_ID String
>>>NOTEBOOK_REV String
>>>PROCPT_SEQ Number
>>>PAGE_SEQ Number
>>>
>>>
>>>Edit Execute Box:
>>>
>>>execute FSRDBA.GET_PAGE_INSTRUCTIONS;0 NOTEBOOK_ID =
>>>:NOTEBOOK_ID,NOTEBOOK_REV = :NOTEBOOK_REV, PROCPT_SEQ = :PROCPT_SEQ,
>>>PAGE_SEQ = :PAGE_SEQ
>>>
>>>EOF
>>>
>>>
>>>
>>
>>
>
>
>