Oracle SP syntax issues
We have a linked server from SQL to Oracle and successfully ran Oracle stored procedures from SQL to insert data. I am attempting to run a different SP that returns data but can't seem to get the syntax correct. My call includes a couple of date fields as parameters and a cursor is returned. Are column names required to be sent in the result set portion of the call?
Software/Hardware used:
Software/Hardware used:
ASKED:
June 5, 2009 2:42 PM
UPDATED:
June 5, 2009 2:58 PM
RELATED QUESTIONS
- Executing Oracle stored procedure from SQL server
- What is the best method to connect Oracle and DB2 DB with HIGH reliability and speed?
- TIME String using Variable H (0 to 23) & M (0 to 59)
- Can you use variables as input and output when calling a stored procedure in COBOL?
- HL7 2.x - query syntax or language
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
