Wanted to whether SQL query can be build in Sub program

arunbai6 · New User Joined: 28 Oct 2014 Posts: 1 Location: USA

Hi All,

Is there any way i can build the sql query in a subprogram by passing parms from the main program. also execute the query in the sub pgm and return the value back to the main pgm. for Direct query like

SELECT COL1, COL2, COL3
FROM TAB_X
WHERE COL1 = :hvar

Marso · Posted: Sun Nov 02, 2014 7:04 pm

Hello and welcome to the Forum.

Exactly which part of the query is to be dynamically built ?

Rohit Umarjikar · Posted: Mon Nov 03, 2014 9:00 am

Create a table which contains 2 columns viz 1. Unquie integer number and other column corresponds to the SQL query. So now pass the parm to this sub program and query against this new table and gives these parms values against the first column and get the corresponding SQL and string it form a dynamic query.