[Tutor] How can I execute a PL/SQL Procedure directly through

Kent Johnson kent37 at tds.net
Mon Jul 30 16:43:54 CEST 2007


Amit Saxena wrote:
> ya i m trying to execute the procedure,these were the contents of that 
> SQL file which i m trying to execute

Then (paraphrasing Greg's earlier response) you need something like
query = "SELECT Create_Process_Team(%(org_id)s, %(org_desc)s, 
%(org_team)s, %(sessioner_id)s)"
results = db.execute(query, locals())

where org_id, org_desc, org_team and sessioner_id are existing local 
variables.

Kent



More information about the Tutor mailing list