It is a complete PL/SQL Cursor which is written in this "metadata.sql" file
On 7/30/07, Greg Lindstrom <[EMAIL PROTECTED]> wrote:
>
>
>
> On 7/30/07, Amit Saxena <[EMAIL PROTECTED]> wrote:
> >
> >
> > I m still not able to run a Procedure
> >
> > from cx_Oracle import makedsn
> > import adodb
> >
> > db = adodb.NewADOConnection('oci8')
> > connection_string = makedsn(" 10.200.91.27 ", 1521, "scorpio") #<==
> > your values here, of course
> > db.Connect(connection_string, "kcmdev", "devkcm") #<== and here, too
> >
> > #query = "SELECT * from USER_ROLE where ROLE_FK = 29"
> > results = db.Execute("metadata.sql")
> > print results
> >
> >
> > is giving an error saying
> >
> > Traceback (most recent call last):
> > File "D:/Python/sql.py", line 9, in <module>
> > results = db.Execute("metadata.sql")
> > File "C:\Python25\Lib\site-packages\adodb\adodb.py", line 274, in
> > Execute
> > c = self._query(sql,params)
> > File "C:\Python25\Lib\site-packages\adodb\adodb.py", line 265, in
> > _query
> > raise sys.exc_info()[0] ,str(err)+': '+sql
> > DatabaseError: ORA-00900: invalid SQL statement
> > : metadata.sql
> >
>
> What is in metadata.sql? If it is a PL/SQL query, then you should "SELECT
> metadata()". If is a file containing sql (is the pl/sql you wish to execute
> in this file?) then I'm not sure how to proceed.
>
> Is the PL/SQL you wish to run saved in Oracle? Can you show us what's in
> the metadata.sql file?
>
> --greg
>
--
Thanks and Regards,
Amit Saxena
Senior QA Engineer
Ketera
Direct: +91 4199 5028
Mobile: +91 99001 18641
[EMAIL PROTECTED]
» Visit us at http://www.ketera.com
» Watch the demo at http://www.ketera.com/resources/demos.html
_______________________________________________
Tutor maillist - Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor
