Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Post
Register
Login
1
Reply
Generating a Oracle SQL Cursor from a user entered SQL Query
Thusith Abeyrathne
Feb 25 2015 3:18 AM
658
Reply
I'm Currently working on a small project where i have to generate a fully functional
Oracle Curosr text (with params) based on a SQL query the user enters. I'm planing to do this as a C# program.
currently having problems with generating the parameters for the Cursor.
Ex:
if the user enters something like:
SELECT a , b, c FROM TABLE t WHERE t.d = d_ AND t.e = e_
the generated cursor text should be like:
CURSOR get_data(d_ datatype , e_ datatype) IS
SELECT a,b,c
FROM TABLE t
WHERE t.d = d_
AND t.e = e_ ;
it'll be great if someone can explain me what approach to take on this
Thanks in Advance.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Shortcut Virus Remover
Convert code C# 2008 to code C# 2005 ?