Categories
- All Categories
- Oracle Analytics Learning Hub
- 32 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 255 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 95 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Calling stored procedure on Button click using Javascript function
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...
Answers
-
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
0 -
@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
0 -
Thank you for your reply...
0