Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467

    Unanswered: insert via .ASP problem

    setup: 9iDB, W2K

    I have stored procedure that I am calling from an .ASP script. The procedure is doing an insert but the record never gets saved into the data base. I am able to call the stored procedure from sqlplus and it works fine. I have even gone to the point of putting "Commit" statements in my stored procedure but that does not help.

    I have tried verifying the DSN that is on the platform but there was no available program to test with. It appears that it will take an act of God to get one loaded. I did copy ODBCTST.EXE from a 6i installation but it failed. I am not certain if it failed because of the DSN or because of some missing .dll.

    Any suggestions would be greatly appreciated.
    NOTE: Please disregard the label "Senior Member".

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    To this reader your problem description is less than clear.
    I am unlcear WRT how many different machines and applications are in the mix.
    Would I be correct in saying that an ASP is Microsoft's equivalent to a Java Service Page?
    If so, to me I would conclude that the ASP "runs" in/on some sort of WebServer (IIS? perhaps).
    Would I be correct to say that you desire to invoke PL/SQL from a browser?
    On of the ways I know how to invoke an Oracle stored prodecure is from Apache running the mod_plsql plugin.
    I suspect that the INSERT does NOT occur, becuase you do not ever really get into the Oracle DB PL/SQL engine.
    One rude & crude way to try to verify would be to enable AUDIT to the max and
    delpoy a LOGON trigger which records all logins.

    HTH & YMMV
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    Sorry for the lack of clarity. Hope this helps.

    ASP ("active server page" I believe) is a Microsoft web method for accessing data bases (my understanding). We are serving web pages (Oracle reports) via IIS (Reports Server). The web page contains a form method that calls log.asp which in turn calls an oracle stored procedure to insert the data.

    Your suspicions mirror mine.

    Thanks for your suggestions Ana. (and for the charity with which you dealt with my lack of clarity :-) ).
    NOTE: Please disregard the label "Senior Member".

  4. #4
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    If you want to check you are connected look at v$session (or oem). And to see if your procedure is being called look in v$sqlarea for the procedure name. If necessary do alter system flush shared_pool to clear out v$sqlarea (well most of it anyway).

    Alan

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Browser<-->WebServer<-->ApplicationServer<-->DatabaseServer
    It would be helpful to know vendor & version of each of the components.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •