10x for your replay,
im trying to pass a boolean value in Python to an Oracle database procedure(to PL/SQL BOOLEAN value that my Oracle procedure getting)
my oracle procedure is getting to values:1. varchar value,2.boolean value
and i want to execute this procedure from my python code, and i dont know hot to pass the boolean value to the Oracle procedure.
hydroxide8
Last Activity: Jun 26 '08, 07:43 PM
Joined: Dec 7 '06
Location:
-
how to pass PL/SQL-BOOLEAN argument to procedure in Oracle
hey
im using cx_Oracle to connect my python code to Oracle database,
and i wanted to know how can i pass PL/SQL-BOOLEAN argument to procedure ?
my code is something like "cursor.execute (query,varList) "
where query is "begin SYS.MYPACKAGE.M YPROCEDURE(varc harArg => :1,booleanArg => :2); end;"
and varList is my argument list, and the second argument need to be of type BOOLEAN, how can i achive... -
help with the use of "callfunc" function ?
hey
im using the cx_Oracle module and i want to run a function that return obejct of VARCHAR2 type, and i dont know how to do that with the "callfunc" function..
i was try this :
result = cur.callfunc("F UNC_NAME",cx_Or acle.VARCHAR2,p arameters)
and this:
result = cur.callfunc("F UNC_NAME",cx_Or acle.STRING,par ameters)
but it was not working..
can someone... -
rewrite to file
i want that my prog will rewrite (update) to exsist file if it was found a string im searching for inside this file, so i did this:
fptr=fopen("dat a.txt","r+"); // i also tried "a+"
fscanf(fptr,"%s \n",tmp_name) ; //tmp_name is a vector.
if (strcmp(myname, tmp_name)==0)
{
fprintf("%d %d %f %d",won,lost,av g,best);
}
fclose(fptr);
my file...
No activity results to display
Leave a comment: