Hi.
i am new on apex and will like to know if can help me with my question.
i am calling an on demmand process from jquery javascript to insert some data on oracle apex_collection (i do delete and insert on the apex collection and works fine) , but i need to insert an oracle database table directly from jquery (through an on demmand process or any other way).
actually, i have an html page with an anonymus pl/sql which shows a list of items where user enter some values; using javascript, i call an on demmand - javascript process that will do the insert on an oracle table, but nothing happens. no data get inserted to my table
actually i am calling the on demmand process using this on javascript, and works nice, but only on apex_collection , not on oracle database table.
var ajaxRequest = new htmldb_Get(null,&APP_ID.,"APPLICATION_PROCESS=ADD_PRODUCTS",&APP_PAGE_ID.);
ajaxRequest.add('P1_PRODUCT_ID',html_GetElement('P1_PRODUCT_ID').value);
ajaxRequest.add('P1_QTY',html_GetElement('P1_QTY').value);
ajaxResult = ajaxRequest.get();
it is importante to mention that i am NOT SUBMITTING or refreshing the page at any time, because it will make it too slow, I think it has something to do with the problem but not sure.
thanks in advance.
Anthony.