Oracle/PB error message

[Jacqueline]

Environment: Windows Vista, PowerBuilder 8(I think, well it least according
to pb dlls), Oracle 8.1.7.4 (client 10GR2).

An attempt was made to execute sql statement (users can type themselves-sql
on the fly...), and execute on Oracle that will return results in the botton
half of Powerbulder window. We are trying to test this application on
Windows Vista operating system and received the following error. Does
anyone know what this means? Is it correctible? How do I correct it?

Thx.

Error:

Select error: This cursor based stored procedure has no columns.
Check the PBDBMS DbParm and the procedure syntax.

[Jacqueline]

Actually it was Powerbuilder 8.0.3 build 9860...

"Jacqueline" <jacquelin...@medtronic.com> wrote in message
news:4980abfb$1@forums-1-dub...

[Jerry Siegel [TeamSybase]]

I gather from the guess at PB version that you have a packaged application
rather than one you wrote, and don't have the source code to look at. If it
is indeed PB 8 you are lucky that it runs at all - 11.1 was the first
version tested on Vista.

Does this happen for every SQL statement? Try something trivial like select
sysdate from dual.

"Jacqueline" <jacquelin...@medtronic.com> wrote in message
news:4980abfb$1@forums-1-dub...

[Philip Salgannik]

Doesn't look like it has anything to do with Vista...

"users can type themselves-sql on the fly" sounds like disaster in the
making though...

"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message
news:4980afc9@forums-1-dub...

[Terry Dykstra [TeamSybase]]

Based on that message you are not submitting a basic "select * from table"
statement, but actually trying to execute a stored procedure.

You'll have to provide more detail of what the program is doing. Show us
some code.

--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

"Jacqueline" <jacquelin...@medtronic.com> wrote in message
news:4980abfb$1@forums-1-dub...

[Jerry Siegel [TeamSybase]]

Probably not, I should have asked if it does the same on XP.
"Garbage in..." <G>

"Philip Salgannik" <philema...@comcast.net> wrote in message
news:4980bbc9$1@forums-1-dub...

[Jacqueline]

Actually it was Powerbuilder 8.0.3 build 9860...

"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message
news:4980afc9@forums-1-dub...

[Jacqueline]

It's not the query, it's the connection to database that's causing the
problem. I used a basic query - "select * from dual".

"Jacqueline" <jacquelin...@medtronic.com> wrote in message
news:4980abfb$1@forums-1-dub...

[Jacqueline]

On XP it works fine.

"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message

news:4980be5f@forums-1-dub...

[Jim Madderra]

What does the stored procedure code look like?

What does the call to the procedure look like (an example of one that is
failing)?

"Jacqueline" <jacquelin...@medtronic.com> wrote in message

news:4980cd34$1@forums-1-dub...

[Bruce Armstrong [TeamSybase]]

It look like it's using the old PBDBMS method of calling stored
procedures in Oracle and getting result sets back to PowerBuilder.
That particular approach was only useful for Oracle 7 and earlier
(back when they didn't support REF CURSORS).

Run, don't walk, away from that method. Recode the procedure to use a
REF CURSOR and your datawindow to call that:

http://pbdj.sys-con.com/node/42529

On 28 Jan 2009 11:03:23 -0800, "Jacqueline"
<jacquelin...@medtronic.com> wrote:

-----------------------------------

My Web 2.0 Stuff

Blog: http://bruce.pbdjmagazine.com/
Facebook: http://www.facebook.com/people/Bruce-Armstrong/1600223798
Fotki: http://public.fotki.com/brucearmstrong/
LinkedIn: http://www.linkedin.com/in/bruceaarmstrong
Twitter: http://twitter.com/bruce_armstrong
YouTube: http://www.youtube.com/user/brucearmstrong