Re: [GENERAL] [ADMIN] returning results from plsql function to plpythonu function

2011-12-03 Thread c k
thanks. it solved my problem. C P Kulkarni On Sun, Dec 4, 2011 at 12:21 AM, Lou Picciano wrote: > # Assuming your query here returns col1, col2, etc.: > > results = plpy.execute("select * from software.func1();") > > # these lines will return the results -- > # - (where the first member

Re: [GENERAL] [ADMIN] returning results from plsql function to plpythonu function

2011-12-03 Thread c k
when I modified the notice statement as plpy.notice('%s' %results[0]) it prints notice as NOTICE: {'func1': 'function return text'} I didn't understand why it is showing 'func1' in the results[0] ? C P Kulkarni On Sat, Dec 3, 2011 at 11:31 PM, c k wrote: > can you please give me the example

Re: [GENERAL] [ADMIN] returning results from plsql function to plpythonu function

2011-12-03 Thread c k
can you please give me the example I am not a python programmer. C P Kulkarni On Sat, Dec 3, 2011 at 11:25 PM, Lou Picciano wrote: > CP - You're missing a line in the middle; one which will extract specific > content(s) from $results. > > Because, yes, without such a line, python will only retu