function based index

I have created a function based index on one column , but query is still noy using it . What should be the reason ? oracle 8.1.7 cost based optimizer table and index analyzed recently

Re: a PL/SQL question - how to catch errors without going into except

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Big Planet INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: recordset as argument

Yes Shishir you can pass refcursor to a procedure . -Bp - Original Message - From: Shishir To: Multiple recipients of list ORACLE-L Sent: Thursday, April 04, 2002 5:08 AM Subject: recordset as argument Hi Gurus ! Is it possible to pass recordset or

Re: SEQUENCES

list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Big Planet INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: Insert statement hangs

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Big Planet INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

another listener.ora

How can I start another listener on same box using another listener.ora file . TIA Bp

Re: One sql statement

command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Big Planet INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

who compiled this proc

How to find which database user and ip-address compiled this stored proc ? -Bp

urgent

Hi Guys , I am getting this weired result after executing stored proc . When I run a particuler stored proc which returns two refcursors ( inside proc theresare dynamic query ) multiple times the proc executes well ...but after someexeccution ( using same connection ) the

sysdba and sysoper roles

Hi Guys , I need some info here , What exactly is difference between sysdba and sysoper roles and how can I set up osdba osoper roles on unix ( i mean what os permissions does it need ). -ak

Re: PL/SQL Question

from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Big Planet INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELOG mo

: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Big Planet INET: [EMAIL PROTECTED] Fat City Network Services

calling program

Hi LIst , Is there a way a pl/sql procedureor function can know the calling procedure or calling program . -ak

Re: calling program

on DBMS_UTILITY..FORMAT_CALL_STACK. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Jack C. Applewhite To: Multiple recipients of list ORACLE-L Sent: Friday, March 15, 2002 4:23 PM Subject: RE: calling program Big Planet

effiecient query ?

I have a system which stores messges in database ( just like out email messges ) and table having fileds like sent-to , from , cc, bcc , new_indicator (y/n) , draft_indiacator , receive-date , ... I have to write a proc to seach messages based on different criterian like , all messages from

Re: intermediate table

create or replace type typ_plsqltables_pkg_obj as object (sql_line varchar2(4000));/create or replace type typ_plsqltables_pkg_tab is table of typ_plsqltables_pkg_obj;/ CREATE OR REPLACE PACKAGE plsqltables_pkg IS TYPE t_out_cur_typ IS REF CURSOR; PROCEDURE tabledata( o_cur OUT

Re: Design Issue - Quick response appreciated

Rao , Does it mean you want all the transaction in that session .If yesthen ,Do you keep session_id somewhere ? -BigP - Original Message - From: Rao, Maheswara To: Multiple recipients of list ORACLE-L Sent: Friday, September 21, 2001 9:35 AM Subject: Design

Re: ORA-04030 error

Yes . - Original Message - From: Jeram To: Multiple recipients of list ORACLE-L Sent: Sunday, September 16, 2001 8:10 PM Subject: Re: ORA-04030 error Have applied oracle Patch set for 8.1.7.? Rgds/jeram -Original Message-From: Big

Re: ORA-04030 error

on the import to 1 mb. Jon Walthour -Original Message-From: Big Planet [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 9:40 PMTo: Multiple recipients of list ORACLE-LSubject: ORA-04030 error Hi All , I am getting this error ORA

ORA-04030 error

Hi All , I am getting this error ORA-04030 out of memory when importing in 8.1.7 Solaris 8 . There is no data in import it is just empty tables and stored procs .The error comes with one stored proc . Any Idea how this can be solved . TIA , -BigP

dbms_utility.compile_schema

Is there something wrong with dbms_utility.compile_schema . When I tried to use it , I left with few invalid objects . But if I manually compile those objects using alter package *** . they get compiled . Any Idea why ? BIgP

nvl not using index

what surprise me more is that if i use where clause as ( p_loginid is null or p_loginid=loginid ), it does not use index as well . Why ?? - Original Message - From: Big Planet To: Multiple recipients of list ORACLE-L Sent: Monday, September 10, 2001 2:17 PM Subject: nvl

nvl not using index

Hi All , I am writing this proc does a searchin databasebased on these in parameters and returns a ref cursor . Now one more of these in parameters can be null and my query should return data neglecting null parameters . So I use nvl in the query as shown below . Now my problem is , the

characterset problem

Hi there , We have UTF-8 database. We are using OAS with UTF-8 setting and java at front end connects to OAS socket to send data to be inserted into oracle .Is it required to convert data send by Java to be converted to UTF8 ? OAS (OAS NLS_LANG=AMERICAN_AMERICA.UTF8)When we send some

Re: characterset problem

of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Big

Re: Design Question - Thoughts Needed

FAQ: http://www.orafaq.com -- Author: Big Planet INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

OAS problem

one of my proc returns millions of bytes of data from using oas. If I use stateless i.e. i just give POST /dcd/proc_name?para1para2 it works okay but if I issue POST ,HOST , CONTENT LENGTH ( stateful ) my data get corrupted at some specific position . Any hint why ? Big P

Ora Net problem , help.....

Is it possible that it can be networking or OS problem , when I send the data across network after some 7000 bytes data is getting corrupted carriage return or linefeed are added in between data . Any Expert -Bigp - Original Message - From: Big Planet To: Multiple

HTP print problem

Hi List , I am having a weird problem here . I am using OAS and my stored proc used htp.print to return data .Now when data size becomes very large ..i am getting junk character at some position at the other end where java is reading data on socket. have any of u faced similer problem.. any

Unix question

hel script and then edit that file . Actually I have this configuration file for my system which have keywords like $HOSTNAME$ , $SCHEMA$ which I want to replace with actual values at the time of installation by asking questions to the user. TIA --Big planet

Re: Unix question

" domainname= "abc".foo.bar.com while I want it to be like hostname = abc.acme.com schemaname=schem domainname= abc.foo.bar.com - Big Planet - Original Message - From: Charlie Mengler To: Multiple recipients of list ORACLE-L Sent: Friday