OraFAQ Forum: SQL & PL/SQL » creating and calling procedures

Home » SQL & PL/SQL » SQL & PL/SQL » creating and calling procedures

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

creating and calling procedures [message #21296]

Thu, 25 July 2002 02:17

madhuri
Messages: 12
Registered: August 2001

Junior Member

1)Create a procedure which returns a record set.
ex:- select * from

This procedure returns all rows of the table
How to create?

2)How to call this stored procedure in visual basic application which returns the record set.

Report message to a moderator

Re: creating and calling procedures [message #21306 is a reply to message #21296]

Thu, 25 July 2002 08:54

andrew again
Messages: 2577
Registered: March 2000

Senior Member

http://osi.oracle.com/~tkyte/ResultSets/index.html

Report message to a moderator

Re: creating and calling procedures [message #21365 is a reply to message #21296]

Tue, 30 July 2002 05:31

paritosh agrawal
Messages: 8
Registered: May 2002

Junior Member

same probs with me. m soft dev from noida.pls help me.mail me at paritosh_a@yahoo.com

Report message to a moderator

Previous Topic:	Trigger connect to different database?
Next Topic:	how to see all constraints in SQL?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 17:52:05 CDT 2024