Try:
loSQL.Execute("begin package.function(para1, para2); end;")
as your SQL string. The same is true for SPs and functions.
HTH.
>i can execute sql statement with use wwsql class,
>but how can i execute package, procedure or function from oracle in VFP web connection ?
>
>this is example to execute sql statement :
>lcFile=SYS(2015)+".TXT"
>loSql = CREATE("wwSQL")
>loSQL.Connect("server=(local);driver={Oracle ODBC Driver};database=;uid=;pwd=")
>loSQL.cSQLCursor = "TQuery"
>loSQL.Execute("select * from tablename")
>IF loSQL.lError
>THIS.ErrorMsg("SQL Error",loSQL.cErrorMsg)
>else
>COPY TO (lcFile) TYPE DELIMITED
>*** Send the Delimited string over the wire
>Response.Write(File2Var(lcFile))
>ERASE (lcFile)
>USE IN TQuery
>endif
>
>thanks for your attention
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao