Create Custom Log Files?

Jan 2, 2007

if there is a way to create a custom log files or if there is way to utilize the built in log function of Oracle. Here is the code with what I am trying to do:

IF (_CONDITION IS NOT NULL) THEN
IF (V_CONDITION <> 'NS' OR V_CONDITION <> 'NE' OR V_CONDITION <> 'AR' OR V_CONDITION <> 'OH' OR V_CONDITION <> 'SV') THEN

[Code]....

Ok, so where you see V_CONDITION := 'XX'; I would like to have the value of V_CONDITION be input into a log file as apposed to changing the value to XX. So I would have something like:

RAISE BAD_CONDITION_CODE;

The problem is that I am not sure how to create the actual log file that the value of V_CONDITION will be stored in.

View 2 Replies


ADVERTISEMENT

Forms :: Test Custom Jar Files With 6i From Desktop?

Dec 18, 2010

I want to test custom Jar files with Forms 6i from my desktop, but I cannot get the Run Form->Web to work. Is it possible for the run time to load the just jars for PJC when you do Run Form -> Client/Server? So far, when I have done this, it does not execute any PJC.

View 2 Replies View Related

Server Utilities :: How To Create Parameter Files

May 20, 2011

How to create parameter files i.e. (.par) files for expdp/impdp..

View 1 Replies View Related

Data Guard :: Drop And Create Log Files?

Dec 8, 2009

I would like to increase the size of my redo logs. For this I need to drop & recreate them. I have read the Oracle doc [URL] which covers this however :

I have both "normal" and "standby" redo logs (see below) on my primary database - can I drop the standby redo logs? Do these have a link to the redo logs on the standby database?

SQL> SELECt * from v$logfile order by 1;

GROUP# STATUS TYPE MEMBER
---------- ------- ------- ------------------------------------- 1 ONLINE D:ORACLEORADATAREDO01.LOG
2 ONLINE D:ORACLEORADATAREDO02.LOG
3 ONLINE D:ORACLEORADATAREDO03.LOG
4 STANDBY D:ORACLEORADATASTDBYREDO04.LOG
5 STANDBY D:ORACLEORADATASTDBYREDO05.LOG
6 STANDBY D:ORACLEORADATASTDBYREDO06.LOG

View 4 Replies View Related

Application Express :: How To Create Multiple PDF Files

Jan 12, 2013

I have two tables, one with the customer address and another one with a note. May I know how to create a separate PDF file (for each customer) that should start with the customer name/address (from customer table) and followed by a note (from the note table)

View 35 Replies View Related

Forms :: Create A Form To Store Any Excel / Word Files?

Jul 1, 2011

i m using oracle 10g forms.

i want to create a form where i can store any excel / word etc files.

View 6 Replies View Related

Precompilers, OCI & OCCI :: Make Files That Compile PC Files In Unix

Jul 31, 2008

I have written make files that compile .pc files in unix. This was for several projects that use an oralib source code directory.Just running proc on one target .pc file works fine on unix. I am trying to use proc - Oracle 10.2.0 - in windows and I keep getting:

Quote:unable to open include file
#include <stdio.h>
and other C library headers.

I am doing all development under cygwin, this way I can write a makefile just like under unix instead of using nmake.All C library headers are in /usr/include When I run proc on Solaris as that:

proc program.pc
No problems, and I do get program.c.

However in windows I get the previous error message. I have tried to do proc include=/user/include program.pc and proc include=/user/include parse=full program.pc but I still get the same error message.

View 3 Replies View Related

Know If Database Files Are On File System Or Raw Files?

Oct 11, 2012

How can I know if database files are on file system or raw files?

View 4 Replies View Related

Compare Two Dump Files And Their Respective Log Files

Jun 20, 2012

I want to compare two dump files and their respective log files, to see the difference. Is there any way.

View 8 Replies View Related

Clob Handle In Custom Type In PHP

Apr 17, 2013

I created a custom type what it has a clob member variable:

CREATE TYPE custom_type AS OBJECT(
c_type INTEGER,
c_number NUMBER(38, 8),
c_varchar2 VARCHAR2(4000 CHAR),
c_clob CLOB,
[code]........

The inserting and updating works with constructor: ... custom_type (to_clob('foo')) . But if the data is longest than 4000 characters then the PHP isn't access to it.

So:
The normal case:
$sql = ("INSERT INTO table ( clob_field ) VALUES ( EMPTY_CLOB() ) RETURNING clob_field INTO :clob");
$stid = oci_parse($conn, $sql);
$clobdescr = oci_new_descriptor($conn, OCI_DTYPE_LOB);
oci_bind_by_name($stid, ':clob', $clobdescr, -1, OCI_B_CLOB);
oci_execute($stid);
$clobdescr->save('more than 4000 chars');
...

This case:
I tried:
$sql = ("INSERT INTO table ( ctype ) VALUES ( custom_type(EMPTY_CLOB()) ) RETURNING ctype.c_clob INTO :clob");
$stid = oci_parse($conn, $sql);
$clobdescr = oci_new_descriptor($conn, OCI_DTYPE_LOB);
oci_bind_by_name($stid, ':clob', $clobdescr, -1, OCI_B_CLOB);
oci_execute($stid);
$clobdescr->save('more than 4000 chars');

ORA says: "ORA-00904: CTYPE.C_CLOB: invalid identifier";

How to?Or how to access with any solution?

View 2 Replies View Related

SQL & PL/SQL :: Creating Custom Error Message

Apr 24, 2013

I am trying to create my own error message but when ever i used sp_addmessage it gives error sp2-0734 unknown command biggning... what to do?

View 12 Replies View Related

Forms :: Add Some Custom Image On A Button?

Dec 7, 2010

Is it possible to add some custom image on a button?

If so, How to do it?

View 8 Replies View Related

Custom Size Reports For Printing With Linux

Aug 22, 2007

I have developed few reports for ebusiness suite in various sizes as 8.5 * 8.5, 8.5*11 and 8.5 * 12.My OS is Linux Red Hat 8.5 and the printer is Epson LQ 300. All the reports are TEXT and I am facing a printing problem to print in various sizes as we need to print all these reports by using a single printer.I created different print queues with the default paper sizes as above mentioned to print the reports, but the printer never considers any specified paper size and always printing for the default A4 size of 8.5 * 11.

View 1 Replies View Related

Forms :: Change Block Status In Custom.pll?

Mar 9, 2010

I have a requirement to get decrypted value of national_identifier from database and display in Social Security number, when user queries for employee in employee form of HRMS. Also, National_identifier should be in encrypted format in database table always.

To meet above requirement, I am using custom.pll. In WHEN-NEW-BLOCK-INSTANCE I am getting decrypted value of national_identifer from database and assigning it to :person.national_identifier(database block) by using COPY function, so far it is working as expected.

When user query for employee, he/she able to decrypted value. but if user closes the form it is asking 'Do you want to save changes you made' as there is a change in :person.national_identifier.

Do we have any property to reset record/block status to something like unchanged, so we will not get 'Do you want to save changes you made message'.

View 15 Replies View Related

Forms :: Where To Set Auto Refresh On Custom Form

Dec 14, 2010

How and where to set Auto Refresh on Custom Form ...?

View 1 Replies View Related

SQL & PL/SQL :: Find And Trace Custom View / Procedure?

May 24, 2013

I know that this query had been executed again the db, but the person is no longer here. Last run was about 3~4 months ago.

SELECT Subject_ID,
TO_CHAR (completed_date, 'mm/dd/yyyy'), status
FROM ADMINDBG_USER.adbt_master
...

[ADMINDBG_USER.adbt_master] is not a part of [dba_tables]. [ADMINDBG_USER.adbt_master] must be a view/procedure/a sort.
I have no luck to find what view/procedure/syntax is populating the data onto [ADMINDBG_USER.adbt_master].

View 7 Replies View Related

Forms :: Compare Value Which Is Taken In Custom Block By User

May 26, 2010

i have created one custom block in that i am taking one value in text_item and on 2nd form i have data block on that block i want filter by using WHERE clause

in that where clause i want to compare value which is taken in custom block by user..what need to write in where clause?

View 1 Replies View Related

Workflow :: Custom AWE Line Level Approval?

Jul 25, 2013

creating custom AWE Line Level Approval? I’m having trouble trying to get the method for line approval to fire. I have header level working so I decided to dig deeper. I added the line keys to the Xref table, Updated the Registry, Configured the Events, and created a new Process Definition using line level (very simple “Always True”). I have seen OnProcessLaunch fire so my routing has begun.

The graphics look good. But when my approver goes in and hits the Approve button, it saves and nothing happens to the approval. Tracing it shows that no methods are firing. How does the system know to fire the line level method vs the header level method?

View 0 Replies View Related

Application Express :: Deploy Custom Applications

Mar 19, 2013

I have developed a custom application in APEX. I wants to deploy and make it as a web application so that it can be access through url.

View 1 Replies View Related

Application Express :: BIP Custom Report Layouts?

Jan 11, 2013

use BI publisher to create custom report layouts, which are uploaded via APEX in the Shared components reports area.

The users wish to be able to select which report layout they want to use on the fly, e.g. select from drop down list which I'd hope to dynamically populate without having to hard code the report layout names into it.

From what I can find, it’s been stated that the layout names etc are stored in wwv_flow_files. However when I look here, I see all “history” of the files, even report layouts that were created and then subsequently deleted.

how, I can retrieve the details on exactly what report layouts are “active”?

View 0 Replies View Related

Spatial :: Oracle Geocoder With Custom Data

May 9, 2013

I'm testing the geocoded with my custom data from El Salvador. I have configured all the tables required. My GC_PARSER_PROFILEAFS is:

<address_format unit_seperators="," replace_hyphen="true">
<address_line>
<place_name />
</address_line>
<address_line>
<street_address>
[code]....

Why I'm I getting null when searching for streets and not getting all the geocoded data right?

View 1 Replies View Related

Forms :: How To Implement Custom Lov Button Without The Standard Template.fmb

Jul 4, 2010

i am developing a application using oracle forms 10g. i can't use the standard template.fmb because my application does not run in ebs. there comes the problem: i want to implement the lov button function like the template does, such as :

1. when the text item get focus, lov button display.

2. when the text item lost focus, lov button disappear.

3. when scrollbar scrolls, the position of lov button adjust accordingly.

4. there is only one lov button in one form and the lov button was created dynamically.

View 2 Replies View Related

SQL & PL/SQL :: Custom Date Or Data Type To Compare Semesters

Jul 26, 2011

I have a table with two columns called startsem and gradsem they are both CHAR(3). Within those colums are rows that are listed as SemesterYear. For example, F09 is Fall 2009, S09 Spring 2009, and M09 is Summer 2009. I would like to create a constraint that says GradSem must be greater than StartSem b/c no one can travel back in time to graduate. However, as you know you can compare S09 > F09 because it will treat it as a string. I thought I could use a substring and compare the last two digits as a year and that would work but how do I compare the semesters as a time frame? Because in my schema F > S because Spring 2011 comes before Fall 2011 but in reality F < S because to Oracle it is a string and the ASCII value of F is less than S. I cannot chage the coding of the database so editing the rows so they are more date friendly is not an option.

So how can I modify this database to acruately compare StartSem and GradSem.

View 7 Replies View Related

Forms :: FRM-47023 - No Such Parameter Exists In Custom Form XYZ

Mar 6, 2012

Getting error FRM-47023: No such parameter named CHART_OF_ACCOUNTS_ID exists in our custom form XYZ

View 5 Replies View Related

Implement Custom Logic On Button In Oracle CRM On Demand

Jun 25, 2013

we wanted to know the approach of how to implement our custom logic through button click (which is vanilla) in Oracle CRM on Demand

View 1 Replies View Related

Forms :: Using PIPELINED Return Inside Custom Library

Jun 5, 2013

I would like to know if it's possible to use PIPELINED return inside a custom library with Oracle Forms Builder? For now, i try to use it, but i get error about client side.

my code.

PACKAGE TEST IS
TYPE measure_record IS RECORD(
l4_id VARCHAR2(50),
l6_id VARCHAR2(50),
[code].......

the body compile, but not the other part. I would like after call the select * from test.get_ups(0); with a cursor into another function.

View 3 Replies View Related

Application Express :: Custom Download Procedure Not Working?

Oct 16, 2013

I have created a custom download procedure to download uploaded files from custom table records which are displayed via links and i call my procedure as #OWNER#.my_file?p_file=#ID#. Now the problem this procedure call works in my development system not any other system.

is there any grant i need to provide but i don't want to grant to public also apex 4.1.1  create or replace PROCEDURE

my_file(p_file in number) AS        v_mime  VARCHAR2(500);        v_length  NUMBER;        v_file_name VARCHAR2(400);        Lob_loc  BLOB;BEGIN    SELECT trim(MIME_TYPE), BLOB_CONTENT, trim(filename),DBMS_LOB.GETLENGTH(blob_content)          INTO v_mime,lob_loc,v_file_name,v_length      FROM EMP.FILE_attachments                WHERE id = p_file;     owa_util.mime_header( nvl(v_mime,'application/octet'), FALSE );        htp.p('Content-length: ' || v_length);     htp.p('Content-Disposition:  attachment; filename="'||replace(replace(substr(v_file_name,instr(v_file_name,'/')+1),chr(10),null),chr(13),null)|| '"');  owa_util.http_header_close;                wpg_docload.download_file( Lob_loc ); ---------------------------------

View 14 Replies View Related

Export/Import/SQL Loader :: Impdp Custom Log Path

Oct 18, 2012

I am using the following command for importing data in to oracle database 11g in linux box.

impdp system/test-123 directory=test_dir dumpfile=test.dmp logfile=test.log full=yes remap_schema=test1:test

Here test_dir = /u01/app/oracle/product/11.2.0/db_1/DATABASE/test/dmp

By default the test.log file is getting created in the above said dir (test_dir) but my requirement is I want to have it in a separate dir.

View 13 Replies View Related

Forms :: Custom ORDER BY In Multi-record Data Block

Jun 15, 2011

I have data block that has hundreds of records. On a screen I display 20 records at a time. On that same screen I have "find badge" function where user types badge/employee id and presses a button to find the record in a data block. I have no problem finding the records in a list and pointing the curser to appropriate record. My question is (which is a user request) if the badge/employee id is found to make that record to be the first record in a list.

View 2 Replies View Related

Reports & Discoverer :: Custom SQL Entered Is Not A Valid Statement - ORA-01031

Feb 4, 2011

After validating the SQL statemnet during creating a Custom folder in OracleBi Admin following Error displays. While the same query execute in toad successfully.

The Custom SQL entered is not a valid SQL statement - ORA-01031:Insufficeint Privileges

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved