Powerhouse and Result Sets/Cursors
Adrian.Hudson at eu.averydennison.com
Adrian.Hudson at eu.averydennison.com
Thu Jan 3 06:03:45 CST 2008
Hi All,,
Just for the record, I did not manage to get this working.
I tried both Bob't example and Doug's suggestion about the environment
variable and still got the same error message.
Happy New Year to All,
Adrian
"Moffatt, Doug" <Doug.Moffatt at cognos.com>
Sent by:
powerh-l-bounces+adrian.hudson=eu.averydennison.com at lists.sowder.com
19/12/2007 23:05
To
<powerh-l at lists.sowder.com>
cc
Subject
RE: Powerhouse and Result Sets/Cursors
Hi Adrian,
The Powerhouse source is correct. On your server machine, try setting
the environment variable, STRICT_SQL92=yes.
Regards...Doug
-----Original Message-----
From: powerh-l-bounces+doug.moffatt=cognos.com at lists.sowder.com
[mailto:powerh-l-bounces+doug.moffatt=cognos.com at lists.sowder.com] On
Behalf Of powerh-l-request at lists.sowder.com
Sent: Tuesday, December 18, 2007 1:06 PM
To: powerh-l at lists.sowder.com
Subject: powerh-l Digest, Vol 31, Issue 12
Send powerh-l mailing list submissions to
powerh-l at lists.sowder.com
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.sowder.com/mailman/listinfo/powerh-l
or, via email, send a message with subject or body 'help' to
powerh-l-request at lists.sowder.com
You can reach the person managing the list at
powerh-l-owner at lists.sowder.com
When replying, please edit your Subject line so it is more specific than
"Re: Contents of powerh-l digest..."
Today's Topics:
1. Powerhouse and Result Sets/Cursors
(Adrian.Hudson at eu.averydennison.com)
----------------------------------------------------------------------
Message: 1
Date: Tue, 18 Dec 2007 16:57:57 +0100
From: Adrian.Hudson at eu.averydennison.com
Subject: Powerhouse and Result Sets/Cursors
To: powerh-l at lists.sowder.com
Message-ID:
<OFB361EA54.9B7A67F3-ONC12573B5.0055DD10-C12573B5.00579241 at averydennison
.com>
Content-Type: text/plain; charset="us-ascii"
Hi,
This is my first post, so I hope I manage to follow all the necessary
etiquette!
Has anyone managed to use a cursor with a result set in Powerhouse and
Oracle (This was introduced in 8.4D)?
I'm struggling with how the Cursor/Result Set is passed back (and indeed
defined) in the Powerhouse code.
We are running Oracle 10g with Powerhouse 8.43D1 on AIX
The text below illustrates the problem.
Regards,
Adrian
Create package and procedure
----------------------------------------------
create package powpkg
as
type CursorType is REF CURSOR;
end powpkg;
create or replace procedure return_wishlist (ocursor in out
powpkg.CursorType)
as
begin
open ocursor for select description from hudsona.boys_wishlist; end; /
To demo it works in SQLPLUS
--------------------------------------------
SQL hudsona at DVXD> variable c refcursor
SQL hudsona at DVXD> exec return_wishlist (:c)
PL/SQL procedure successfully completed.
SQL hudsona at DVXD> print c
DESCRIPTION
--------------------------------------------------
Football Game
Keyboard
Shrek DVD
Powerhouse code
--------------------------
sql in css2base &
declare c_cursor cursor for &
call hudsona.return_wishlist &
result set description varchar(50)
acc c_cursor
go
------------------------------------------------------------------------
-------
DMS-E-GENERAL, A general exception has occurred during operation
'execute'.
File: C_CURSOR
------------------------------------------------------------------------
-------
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to
'RETURN_WISHLIST'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
- -----------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you
received this in error, please contact the sender and delete the
material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.sowder.com/pipermail/powerh-l/attachments/20071218/93863039
/attachment-0001.html
------------------------------
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.
End of powerh-l Digest, Vol 31, Issue 12
****************************************
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.
- -----------------------------------------------------------------
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20080103/76eaf24d/attachment.html
More information about the powerh-l
mailing list