cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
higorcc
‎08-08-2023
  • 3 Posts
  • 0 Likes Given
  • 1 Solutions
  • 0 Likes Received

Re: Oracle Store Procedure Execution with OUTPUT in SAS

by Fluorite | Level 6 in SAS Enterprise Guide
‎08-08-2023 12:24 PM
‎08-08-2023 12:24 PM
Hello, The solution is:   Oracle Code: DECLARE OUTPUT1 NUMBER; OUTPUT2 NUMBER; BEGIN           StoredProcedure(99, OUTPUT1, OUTPUT2); END ;   I solved my issue by above code. You need execute this code in PROC SQL.   Thank you. Higor Carvalho. ... View more

Re: Oracle Store Procedure Execution with OUTPUT in SAS

by Fluorite | Level 6 in SAS Enterprise Guide
‎08-01-2023 10:42 AM
‎08-01-2023 10:42 AM
In this case I have a stored procedure with 1 IN (Input) and 2 OUT (output).   For 2 OUT (output) when I execute I need declare these two "output".   In Sql Developer I declare this code and it works, but when I put the same code in PROC SQL with Oracle Connection it doesn't work.   Thank you. Higor Carvalho. ... View more

Oracle Store Procedure Execution with OUTPUT in SAS

by Fluorite | Level 6 in SAS Enterprise Guide
‎08-01-2023 10:25 AM
‎08-01-2023 10:25 AM
Hello, I would like to know, how can I execute Oracle Store Procedure with OUTPUT variable in SAS GUIDE.   In Sql Developer I can execute like you can see below and it works.   Oracle Code: VAR OUTPUT1 NUMBER; VAR OUTPUT2 NUMBER; EXECUTE StoredProcedure(99, :OUTPUT1, :OUTPUT2);   When I declare VAR OUTPUT NUMBER in PROC SQL it doesn't work. Could you please help me with an alternative way to execute this?   Thank you. Higor Carvalho. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-08-2023 04:20 PM
Quick links