Oracle Stored Procedure Returning Table Structure to PowerShell?

If you wanted to use a stored procedure, you would normally return a cursor, i. E CREATE OR REPLACE PROCEDURE sp_test1( p_cursor OUT SYS_REFCURSOR ) AS BEGIN OPEN p_cursor FOR SELECT id, test1, test3 FROM test_table; END Assuming that PowerShell knows what to do with the cursor handle that is returned, that should work. On the other hand, if all you are doing is encapsulating a query, you may want to use a view in Oracle rather than a stored procedure.

Your application can then issue simple selects against the view.

If you wanted to use a stored procedure, you would normally return a cursor, i.e. CREATE OR REPLACE PROCEDURE sp_test1( p_cursor OUT SYS_REFCURSOR ) AS BEGIN OPEN p_cursor FOR SELECT id, test1, test3 FROM test_table; END; Assuming that PowerShell knows what to do with the cursor handle that is returned, that should work. On the other hand, if all you are doing is encapsulating a query, you may want to use a view in Oracle rather than a stored procedure.

Your application can then issue simple selects against the view.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.