Recent content by gerickpa

I am also still learning these stuff. Can you please post the code here? I've looked at the site http://www.jenitennison.com/xslt/grouping/index.html and tried the code advised on the post but I am not getting any result. Also, the format of the XML I'm using is the one that you retrieve from...

Hi ehsant, The problematic line is this: OraDatabase.ExecuteSQL "begin PACKAGE_NAME.SPP_GET_XML (:pv_sSQL, :pv_sXML); end;" which executes the packaged stored procedure. The CreateObject, OpenDatabase and the addition and binding of parameters all go through fine. Of course, in my...

Hi ehsant, I have a stored procedure called SPP_GET_XML defined in a package called PACKAGE_NAME. Its declaration is as follows: PROCEDURE SPP_GET_XML ( pv_sSQL IN VARCHAR2, pv_sXML OUT CLOB); and it supposedly places the XML output into pv_sXML based on the SQL statement passed through...

Hi ehsant, Sorry for not responding back sooner. I got busy with other stuff. Anyway, I was already going in this direction (OO4O) but I got stumped with the error I'm getting. In my ASP code, I defined a parameter (for the XML data) to be an output parameter with the Parameters.Add method and...

Hi all, I have posted this also in the ASP forum but somebody here might have an answer. I am currently using Oracle 8i and been trying to use Oracle XSU in order to generate the resultset of a query as XML. I need to return the XML back to the ASP (Classic ASP, not .NET) page. Since the XML...

Hi all, I am currently using Oracle 8i and been trying to use Oracle XSU in order to generate the resultset of a query as XML. I need to return the XML back to the ASP (Classic ASP, not .NET) page. Since the XML string can exceed 4000 characters, I am returning it from the stored procedure as...