Calling stored procedure on Button click using Javascript function

Question

Hello Experts,

I have a stored procedure in database with 1 parameter (p_file_name). when the user enter the file name.csv on text box and click the apply button it has to execute a procedure which places user file in a directory where the external table is pointed to get data from the uploaded file.

The procedure needs to be updated where sending the file from email can be commented out since they can export the txt file from OBIEE.

I am actually searching for a java script code to execute the SP.

Please help me on this..

TIA...

cool2sathish · Answer

Thank you for your reply...

[Deleted User] · Answer

@cool2sathish as Martin said this has zero to do with OBI and all with pure JS.

Basically you are using nothing at all of OBI. You are simply using it as a webpage which hosts a script. Which means that it will work the same way as if you were doing it from this example: https://www.w3schools.com/html/tryit.asp?filename=tryhtml_basic_document

Also: Please manage your threads and respond to them, close them etc even if the answer is not what you thought it would be.

These forums live with participation

Daniel Willis · Answer

This doesn't really have anything to do with OBIEE and I'm pretty sure is something that can be easily googled.

https://www.google.com.au/search?q=execute+stored+procedure+from+javascript