| Translating Microsoft Transact SQL to PL/SQL. [message #370007] |
Tue, 28 November 2000 01:59  |
Barak Bar Orion
Messages: 1
Registered: November 2000
|
Junior Member |
|
|
Hi,
How do I tarnslate the following Transct SQL
store procedure to PL/SQL.
create procedure foo
as
select * from goo
go
In a way that I could use my old C++ code that call this stored proceudres (with ODBC)
PL/SQL will not let me do select without specify into clause.
Thanks ,
Barak
|
|
|
|
| Re: Translating Microsoft Transact SQL to PL/SQL. [message #370013 is a reply to message #370007] |
Wed, 29 November 2000 11:07  |
Rod
Messages: 3
Registered: November 2000
|
Junior Member |
|
|
|
What you are trying to translate is a cursor, although I understand that T_SQL calls it a procedure. I don't know that you can actually do what you are trying to do. You would be better off just running the query directly if you can't make/call stored cursors. I've never tried to do that.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
