Hi. I need help with clearing geometry cache. In my web application there is a need to clear cache after changing the geometry data in database. I'm using maps with tile layers and for them i want cache to be cleared using triggers in databae. I've tried with passing request to the servlet mcsadmin (using utl_http in pl/sql) with xml(map...
I have discovered recently that's possible to call anoymous blocks from jdbc like this: String plsql = "BEGIN" + " :result := foobar( booleanparameter => :mypar > 2);" + "END;"; con.prepareCall(plsql); Which is great, because I can use this to "wrap" some function calls and overcome some...
Is it a bad practice to do what the code below does? Will bad things happen to me for writing it? Edit: this is just an example. I would not use dbms_output for any real error reporting. CREATE OR REPLACE PACKAGE my_package AS PROCEDURE master; END; / CREATE OR REPLACE PACKAGE BODY my_package AS my_global_interrupt EXCEPTION; PROCE...
Hi, I have a CSV file which contains an ID and several other columns. I also have a table in oracle where the ID identifies a row. How can I best replace the values that are in the table with the values in the CSV file while keeping the other columns the way they were before? This has to be done with tools available in oracle itself (...
Hi all, I'm doing a build script for a Java application to run inside the Oracle JVM. In order to import the 50-odd classes, it appears I need to bring them in in order so any dependencies are present before compilation. For each class, I'm running 'create or replace and compile java source {className} as {classPath}' for each file. D...
Right now I have an Oracle stored procedure with IN and OUT params. The IN params are simple types and collections (customType as table of customObject). The OUT params are a REFCURSOR and some varchars. The thing is: when I send some data-formatted strings to Date IN params, it throws at me this: java.lang.IllegalArgumentException: Tim...
i created a procedure with 32 in argument,it sucessfully created.but when i am executing this in back end oracle the errror came ORA:00900 Invalid sql statement ...
In Oracle we can submit a job to the job queue using the following code: DECLARE X NUMBER; BEGIN SYS.DBMS_JOB.SUBMIT ( job => X, what => 'SYSTEM.INSERTDATE;', next_date => SYSDATE, interval => 'SYSDATE+0.1/(24*60)' ); COMMIT; END; Now my question is when the *interval* paramete...
I've some prob with the function TABLE in ORACLE. SET SERVEROUTPUT ON SIZE 100000; DECLARE int_position NUMBER(20); TYPE T_REC_EMP IS RECORD ( nameFile VARCHAR2(200) ); R_EMP T_REC_EMP ; -- variable enregistrement de type T_REC_EMP TYPE TAB_T_REC_EMP IS TABLE OF T_REC_EMP index by binary_integer ; t_rec TAB_T_REC_EMP ; -- var...
I want to write a SQL query which accepts a bind variable (say :NUM) and its output consists of one column & :NUM number of rows, each row having its row number. i.e. if we pass :NUM as 7, the output should be: VAL ==== 1 2 3 4 5 6 7 There shouldn't be any actual DB tables in query and no PL/SQL code should be used. i.e. only dual sho...
I have a problem in my asp.net MVC application. I have a wrapper class for PL/SQL package. And I have to save screen changes to database through package call. While the process its not throwing any exception or error. How do I debug the package to find where the problem is? Please help me. ...
Hello, I need to generate a ms-word document from a pl/sql query to export a set of reports through a web browser. I have been searching for a specific way to modify the content headers using owa_util.mime_header etc etc but could not really get a working proof of concept to get the web page to present the user to download/open/save a ...
I need to handle the ORA-01400 error (cannot insert NULL into ("SCHEMA"."TABLE_NAME"."COLUMN_NAME") ) using a exception handle. ORACLE Predefine a few Exceptions like (ACCESS_INTO_NULL, ZERO_DIVIDE and so on), but apparently does not define an Exception for the ORA-01400 error, how do I handle this particular error code? I need someth...
I want to check if a variable is null. If it is null, then I want to set a value to that variable: //data type of var is number if Var = null then var :=5; endif But I am geting error in it. How can I check if a variable is null? I am using oracle data type ...
I need to generate unique and consecutive numbers (for use on an invoice), in a fast and reliable way. currently use a Oracle sequence, but in some cases generated numbers are not consecutive because of exceptions that may occur. I thought a couple of solutions to manage this problem, but neither of they convincing me. What solution do ...
hi I want to call create table/ alter table command from a procedure. Is it possible? My requirement is to change the datatype of a column in all tables. So, I am just getting the column name from user_tab_cols. Now I want to create a temp table which requires create statement .. but i am unable to use that within a proc. Can anyon...
Hello, I would like to find out if it is possible to find out which package or procedure in a package is updating a table? Due to a certain project being handed over (the person who handed over the project has since left) without proper documentation, data that we know we have updated always go back to some strange source point. We ar...
I have a compound trigger and in the after statement I have an update to other table that has also a compound trigger, like in the code below: create or replace trigger TRIGGER for insert or update on TABLE COMPOUND trigger after STATEMENT is begin update THEOTHERTABLE set VALUE = VALUE + 1 where COD = 1; end after STATEMENT; end; ...
I'm drawing a design for a system to do daily business functions for my company. It will consist of a Oracle 10g database with Pl/SQL packages and a Java-based web application. All of this is running on a Solaris 10 server. Aside from handling transactions from the web interface, scheduled tasks need to run on the database to run calc...
We have a requirement to store Sharepoint List Data into Oracle. Is it possible to Consumes Sharepoint Webservices(SOAP-based) into ORACLE DB using PL/SQL, like to access _vti_bin/lists.asmx?op=GetList and parse the list data and store in the DB. Has anybody tried this ??? Are there any things (Security, environment) things to consider...