How to write Stored procedure using select query and how to use it in vb.net

[dineshchirayil]

hi

i want to write a stored procedure which return a reocreds of tables.

still now i am not able to write a select query in Oracle stored preocedure.

i am also want to pass table name as parameter. is it posible..?

i am new to oracle databse. . i have toad in my system..using that i am able to create insert query in Storded procedure.but still now i am not able to create a stored precedure which return records..
can any one give one example ?

 

[cjard]

so, you want a procedure that selects all records from a table named as a parameter..

Why dont you just use SELECT * FROM table, as a normal sql?

 

[dineshchirayil]

it showing error...That is y..

Actualy i want pass table name as a parameter

 

[cjard]

Well that's a really helpful answer to my question..