I am encountering an issue with some Oracle code which uses the NCHR function. The same code is running on Windows/Ora10g and Linux/Ora11g, yet it behaves differently. The NLS characterset is identical on both instances. I am trying to determine if this is an issue with Oracle versions or because of the OS. Has anyone encountered thi...
hi, someone could help me because this problem occurs throughout time you run a TRIGGER, but operates in a normal PROCEDDURE TRIGGER: create or replace procedure testeHTTP(search varchar2) IS Declare req sys.utl_http.req; resp sys.utl_http.resp; url varchar2(500); Begin url := 'http://www.google.com.br'; dbms_ou...
Hi! Does anybody have experience regarding deployment of the jBPM Administration Console on Oracle 10g iAS? I successfully deployed it using an .ear, security mappings working, I can even login to the console, Hibernate finds the JNDI datasource but it cannot find the TransactionManager. I see no log, only the exception thrown in the...
I'm trying to run multiple ddl statements within one Execute Immediate statement. i thought this would be pretty straight forward but it seems i'm mistaken. The idea is this: declare v_cnt number; begin select count(*) into v_cnt from all_tables where table_name='TABLE1' and owner = 'AMS'; if v_cnt = 0 then execute immediate 'C...
Friends, In testing our Oracle Forms application on Vista I have found a interesting "challenge". The application can invoke the Microsoft Word spell checker to perform a spell check on a field. When invoked, the user is shown the standard Microsoft Word spell checker dialog window. Word itself is invisble to the user. The Spell Che...
Ok, so i'm a complete newb with oracle. Now that that's out of the way; I think you can get an understand of what i'm trying to do below. For each stored procedure found, output the DDL to a filename with it's name. The problem is i can't figure out how to get the spool target to pick up the value of FileName which is being set by the ...
We have an Oracle 10g forms application running on a Solaris OAS server, with the forms displaying in IE. Part of the application involves uploading and downloading files (Word docs and PDFs, mainly) from the PC to the OAS server, using Oracle's webutil utility. The problem is with large files (anything over 25Megs or so), it takes a l...
I am creating a script that retrieves data from a local oracle db. As of now I have the oracle data provider for .net installed. However, this is a big file and a long installation process. Is there a way to deploy a software that utilizes the System.Data.OracleClient without having to install the data provider? ...
I wanted to check my monthly payroll in which there are employee salary along with other detail. I have created a PL/SQL block but when I place my condition for checking of existing employee id with another table some return null value and hence my table does not go further. set serveroutput on declare emp_id NUMBER :=&emp; temp N...
I need to find out which schemata have already been granted execute permission on a certain object in an Oracle 10g db (in this case, a package). What's the simplest way for me to do this? Is there a built-in function to provide this information? ...
SET SERVEROUTPUT ON DECLARE v_student_id NUMBER := &sv_student_id; v_section_id NUMBER := 89; v_final_grade NUMBER; v_letter_grade CHAR(1); BEGIN SELECT final_grade INTO v_final_grade FROM enrollment WHERE student_id = v_student_id AND section_id = v_section_id; CASE -- outer CASE WHEN v_final_grade IS NULL THEN DBMS_OUTP...
Hi i am using Web Parts in my ASP.NET website. My database is Oracle 10g Enterprise. I wouuld like to know how can i use webparts with Oracle 10g ? How web parts information stoes for authenticated user in database? I am using ASP.NET Form authentication Does it make any performance impact in website? Best practice for improving perfo...
Here is a brief description of the tables I'm working with in Oracle 10g: Notes: Table : jnldetail : Single row with data as shown. There are multiple package id's attached to the same bill_ref_no for an account. Therefore, I'm trying to update "jnldetail " with the multiple package_id's. Relation between index_bill_ref and bill_ref_n...
I have a control file and a data file that look like this: CONTROLFILE1: RECOVERABLE LOAD DATA INFILE "D:\KING\DATAFILE.txt" APPEND CONCATENATE 1 INTO TABLE TABLE1 FIELDS TERMINATED BY ',' TRAILING NULLCOLS ( USERID CHAR(7), COUNTRY CHAR(100), FIRSTNAME EXPRESSION "SELECT USERNAME FROM USER_TABLE WHERE ID=3", ACTIVE_FLAG CONSTA...
I have a table with these columns create table demo ( ID integer not null, INDEX integer not null, DATA varchar2(10) ) Example data: ID INDEX DATA 1 1 A 1 3 B 2 1 C 2 1 D 2 5 E I want: ID INDEX DATA 1 1 A 1 2 B -- 3 -> 2 2 1 C or D -- 1 -> 1 or 2 2 2 ...
i am giving a training project for building a schema the following is the question all i would like to ask you guys is i am not sure what attributes would come in the table please see the problem below... create one new company and attach 10 attributes to the company. the company has two warehouses one in Torrance and another in Costa m...
I'll preface this question by stating that I'm using Oracle 10g Enterprise edition and I'm relatively new to Oracle. I've got a table with the following schema: ID integer (pk) -- unique index PERSON_ID integer (fk) -- b-tree index NAME_PART nvarchar -- b-tree index NAME_PART_ID integer (fk) -- bitmap index Th...
Hello Experts, I have a table with the following fields in Oracle 10g. TABLE_1 account_no | tracking_id | trans_amount Each account_no can have multiple tracking Id's and transaction amounts. How do i query out the duplicate entries of account_no where tracking lies between 1 and 1000, and the corresponding trans_amount ? Many than...
I am designing a new laboratory database. My primary data tables will have at least id (PK NUMBER) and created_on (DATE). Also, for any two entries, the entry with a higher id will have a later created_on date. I plan to partition by created_on to increase performance on recently entered data. Since the columns increase together, t...
create or replace PROCEDURE XXB_RJT_HEADER_PROCEURE ( V_PROD_ID IN NUMBER, V_WARE_ID IN XXB_RJT_HEADER.WAREHOUSE_ID% TYPE, V_PAY_METH IN XXB_RJT_HEADER.PAYMENT_METHOD% TYPE, V_PAY_STAT IN XXB_RJT_HEADER.PAYMENT_STATUS% TYPE, V_ORD_ID IN XXB_RJT_HEADER.ORDER_ID% TYPE, V_ORD_DT IN XXB_RJT_HEADER.ORDER_DATE%...