Click here to Skip to main content
15,908,768 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi,

i want to store the return value of the pl/sql in asp.net,

below function will return cols name of the table
SQL
ALTER FUNCTION dbo.sp_GetTableCols(@TableName VARCHAR(200))
RETURNS TABLE
AS
RETURN (SELECT Column_Name from INFORMATION_SCHEMA.COLUMNS WHERE Table_Schema = 'dbo' and Table_Name = @TableName);
GO


how to store return table value in to a variable in asp.net
Posted
Updated 31-Jan-12 20:04pm
v2
Comments
Rajesh Anuhya 1-Feb-12 2:04am    
Code tags altered.
--RA

You have to write a package for it.

here is the simple example, you will understand better
http://www.akadia.com/services/ora_return_result_set.html[^]

Thanks
--RA
 
Share this answer
 
Hi,

You can create a procedure in a package that returns the SYS_REFCURSOR to the .Net page with data.

Check this link for an example.

CallingOraclestoredproceduresfromMicrosoftdotNET[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900