Forms :: Trigger Program To Track User Information

Jun 25, 2013

I have a trigger program to track updated information's on perks column. I am failing to finish systime in my trigger program.

SQL> desc user_track;
Name Null? Type
----------------------------------------- -------- ----------------------------
EID NUMBER
ENAME VARCHAR2(15)
OLD_PERKS NUMBER
NEW_PERKS NUMBER
UNAME VARCHAR2(15)
ACTION_DATE DATE
ACTION_TIME DATE

SQL> create or replace trigger tri_track
2 After UPDATE ON EMP
3 FOR EACH ROW
4 BEGIN
5 insert into user_track(EID,ENAME,OLD_PERKS,NEW_PERKS ,UNAME,ACTION_DATE,ACTION_TME) values
6 (:old.eid, :old.ename , :old.perks, :new.perks,user, sysdate, to_char(sysdate , 'HH24:MI:SS')
7 from dual;
8 end;
9 /

Warning: Trigger created with compilation errors.

SQL> show errors;
Errors for TRIGGER TRI_TRACK:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2/1 PL/SQL: SQL Statement ignored
3/95 PL/SQL: ORA-00917: missing comma

View 3 Replies


ADVERTISEMENT

Security :: User Locked / Track User Who Hit Wrong Password

Dec 21, 2010

We have the database user called c88888 and is locked yesterday. I came to this with the following query.

select * from dba_users where username like 'C88888';

Due to invalid password the user was locked. Can we track who hit the database with the wrong password?

View 5 Replies View Related

Forms :: How To Restrict User On Key Next Item Trigger

Sep 16, 2011

SQL Plus version Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.1.0 Production
Forms Version : 6i
Reports Version: 6i
O/S : Microsoft Windows Xp professional Version 2002 Service Pack 3

With reference to the above version details here is the requirement. How do I restrict user on key next item trigger i.e I want the cursor to move to next field only when user presses "ENTER" button on the key board any other key like mouse should not allow user to move to the next field.

View 23 Replies View Related

Forms :: Trigger To Capture User Details

Jan 16, 2012

I have a table in that i have some columns along with that four columns to capture the user details. but these details must be captured Programmatically.like whenever a user insert or update or delete his credentials must be captured in these columns. but i am not figuring out in which trigger i have to write and how.

View 19 Replies View Related

Application Express :: How To Capture User Name Information

Mar 5, 2013

I have created a table A say columns a,b,c,d,E. I have created a application to insert and update and delete rows in to this table.I want to capture when some user inserts , update, delete the rows.

How do I set this variable..

View 2 Replies View Related

Application Express :: How To Access User Information

Jan 2, 2013

I am new to Oracle APEX, and have a few questions regarding the user information.

I've created a new workspace on my local APEX installation, created some users in the workspace, and divided them into roles as "Managers" and "Employees". I am the only Dev and Admin of the workspace, and the users (Managers and Employees) I have created are viewers.

I'd like to create database tables in the workspace where some field would refer to the user ID of the created user as a foreign key, and their role. Similarly, I'd like to create pages where a particular region is displayed only if the logged in user is a "Manager". How can I access the user data and the role data using SQL?

I see following tables in my workspace, so which table contains the user information:

APEX$_ACL
APEX$_WS_FILES
APEX$_WS_HISTORY
APEX$_WS_LINKS
APEX$_WS_NOTES

[Code]....

View 2 Replies View Related

Security :: Create Or Modify User Information In OID Using DBMS_LDAP?

Aug 25, 2010

I am trying to create a custom package that creates users as well as modify user information in OID using DBMS_LDAP package. I was able to create the package but I am stuck on specifying the orcladmin password for the procedure DBMS_LDAP.simple_bind_s(my_session,'orcladmin','orcladminpwd');

I need to get the orcladmin password dynamically. Is there a way to achieve this?

We are planning to provide our application users the ability to add new users / modify their own OID information.

View 2 Replies View Related

Find Which User / Program Is Using USERS Tablespace?

Feb 27, 2012

I have a database in which there are lots of programs running by default user or programs started by some oracle users.

Now, I know that the USER tablespace is growing at very high speed - But I dont know which user/program is causing this growth of USER tablespace.

how to identify the program/user who is responsible for this growth of USERS tablespace.

View 1 Replies View Related

PL/SQL :: DBMS-SCHEDULER Program Not Executing As USER But Does As SYS?

Jul 18, 2013

 I'm using Oracle DB 10g EE 10.2.0.3.0 I have created a program to be executed with scheduler. however when I execute the job it fails due to a permissions error.

BEGIN
DBMS_SCHEDULER.CREATE_PROGRAM (
   program_name           => 'Billing_files_organise_prog',
   program_action         => '/home/ora10/data/organise.sh',

[code]...

View 1 Replies View Related

Forms :: How To Track Radio Button ID Or Name In Oracle

Jun 27, 2010

I have a form which contains some block (each block with some text item, two radio groups and a list item). I want to enable/disable and set visible property as true/false for first to last items of each block conditionally. I can do that for all items but radio buttons.

Because to set item or radio button property I need to pass that items ID or Name as parameter. I can get items name/type using get_block_property and next item of that item using get_item_property but unable to get radio button ID/Name using get_radio_button_property or any other built in. To execute get_radio_button_property or set_radio_button_property I need to pass radio button ID/Name. So, how I track radio button id or name in oracle forms? Is it limitations of Oracle forms?

View 8 Replies View Related

Security :: How To Get User Login / Logout Information For Past 30 Days

Feb 3, 2012

I just want to know the user login / log out information for the past 31days. how can i get that?

View 11 Replies View Related

PL/SQL :: Create Trigger To Insert Data From One User To Another User In Same Database?

Apr 16, 2013

I Created One Trigger as Follows

CREATE OR REPLACE TRIGGER TRIGGER1
BEFORE INSERT
ON table1
FOR EACH ROW

[code]......

Here , I Want To Insert The Data From My User To Test User . In This Situation When I Execute The Above Trigger It Shows The Error PL/SQL: ORA-00942: table or view does not exist

View 3 Replies View Related

Server Utilities :: Import Program Without Connecting With Database User

Sep 19, 2011

I want to know if it is possible, to run IMP program without connecting with database user , for example :

imp '/ as sysdba' file=f.dmp fromuer=u1 touser=u2 log=flog.log

that permits to perform scripts without passwords in.

View 8 Replies View Related

Forms :: Keep Track Of Item Value Totals In Header From Items Under Each Activity

Nov 24, 2010

I have three blocks in my form , header,activity and item.One header can have many activities and one activity can have many items.I need to keep track of item value totals in header from items under each activity.

View 1 Replies View Related

SQL & PL/SQL :: Trigger Which Changes Content Of One Column Based On Information Within Another Column

Sep 10, 2010

I am trying to create a trigger which changes the content of one column based on the information within another column.

For Example, if the 'ITEMQUANTITY' field drops below 1 then I want the STATUS column to say 'Out Of Stock'.

View 23 Replies View Related

Precompilers, OCI & OCCI :: Cobol Program That Call C Program

Jan 28, 2011

I have a Cobol program that call C program above

#include stdlib

EXEC SQL INCLUDE SQLCA;
EXEC SQL BEGIN DECLARE SECTION;
char *uid = "puntos/puntos@cmrdesar";
[code]....

Are something wrong in C programm ? Pro*C code from vouters.dyndns.org/tima/OpenVMS-Cobol-C-Cobol_ passing_ variable_ number_ of_ arguments_to_C.html

View 1 Replies View Related

Forms :: Getting Hardware Information In Oracle 6i?

Feb 9, 2010

How Can We Get Hardware Information In Oracle forms 6i for example harddisk size,volume,processor etc.

View 1 Replies View Related

Forms :: Convert Program From 6i To 10g

Dec 6, 2006

I have a program that was developed in Forms 6i.Actually, this program:

- reads a table with a Blob column that contains a MS Word format Document.
- the document needs to be convert , then the program changes some variables that are wildcards.

In forms 6i I use a column with datatype Ole and the flowing procedure that read value from database:

PROCEDURE Pr_Abre_Contrato (pContrato In Contrato.Cont_Numero%Type,
pQuery in Varchar2 ) Is
Workbook OLE2.OBJ_TYPE;
Application OLE2.OBJ_TYPE;
MyDocuments ole2.obj_type;
Args ole2.obj_type;
vWhere Varchar2(200);
[code]....

Now, I need to convert this program to forms10g. I opened the TAR in metalink and the Support said that exec_verb can not be used and it doesn't have another one to replace.

View 26 Replies View Related

Forms :: Executing Program BAT In Another PC In 10g?

Oct 20, 2010

I have forms 10g and use oracle database11. I have a form and I need to execute a program x.bat in another PC.

View 2 Replies View Related

Forms :: Automatic Delivery New Information To Block Under

Dec 26, 2011

I want to a form 10g as image under. Now i want to when item pallet_serial has new information then automatic delivery that information to block under.Example, with this form, i want to deliver information about FROM_LOC, TO_LOC, SEAL_NO, CAR_NO, PALLET_SERIAL... into under block, and after that clear field PALLET_SERIAL for next time input.

View 1 Replies View Related

Forms :: Call One Trigger Of Item In Trigger Of Form?

Jul 1, 2011

How can "call one trigger of item in trigger of form"

View 5 Replies View Related

Forms :: Creating A Program With Two Tables

Jul 19, 2010

I am facing a problem while creating a program using oracle forms.These two table i am using in creating following program .

SQL> desc electricity ;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
NAME VARCHAR2(40)
PREV_READING NUMBER(20)
PRESENT_REDAING NUMBER(20)
TOTAL_UNITS NUMBER(30)
AMOUNT NUMBER(30)
[code]....

What i want that whenever user writes a value in "PRESENT_Reading" Column then it stores value in "ID table" .For example if current month is July ,Then when user write a value in present Reading column ,it stores it in JULY Column of Id table ..i Write following trigger (Key_commit) On present_reading Column .

if sysdate=to_char(sysdate,'MON','Jan') Then
:electricity.PRESENT_REDAING := :ID.Jan ;

elsif
sysdate=to_char(sysdate,'MON','FEB') Then
:electricity.PRESENT_REDAING := :ID.Feb ;

elsif
sysdate=to_char(sysdate,'MON','MAR') Then
:electricity.PRESENT_REDAING:= :ID.MAR ;

But when i run my form it does not work ,and raised unhandled Exception .I think i need to change some properties of PRESENT_READING column of electricity table.

View 7 Replies View Related

Server Administration :: How To Prevent DBA User From Disabling Any Trigger

Jun 19, 2011

How can prevent DBA user from disabling any trigger ? suppose DBA user can't be able to execute following command

ALTER TRIGGER {trigger_name} DISABLE;

how can i protect it?

View 3 Replies View Related

Forms :: Make Print Button To Display Information

Oct 4, 2012

how can i put button in a form to print the information i displayed in this form.

View 1 Replies View Related

Forms :: Open Excel Sheet From PL/SQL Program

Jul 13, 2010

I need to open an excel sheet from PL/SQL program where I will put in the data. How to open an excel sheet from Pl/sql code.I got hold of a code as below Looks like I need to configure DAD PL/SQL

BEGIN

-- Prepare Headers
owa_util.mime_header('application/vnd.ms-excel',FALSE);
--htp.p('Content-Length: '||document_length||NL_CHAR);
--htp.p('Content-Length: '||document_length);

[Code]....

View 4 Replies View Related

Forms :: Inventory Sale Program In Oracle

Apr 15, 2010

I have made the inventory sale program in oracle. Its working from 7 years. Now its speed is very slow.It take much time to execute query.

View 17 Replies View Related

Forms :: Using A Java Program In Bean Area?

Jul 13, 2010

I want to use a java program in Bean Area.

But I can't understand the implement class and how it is implemented.

View 1 Replies View Related

SQL & PL/SQL :: Create Trigger That Will Fire Whenever Any User Will Access Schema Of Oracle

Oct 31, 2011

I would like to create a trigger that will fire whenever any user will access to a Schema of Oracle DB (for each and every login). regardless the access will be through an application or SQLPLUS and this trigger must insert the below information into a table.

1) IP address
2) Machine Name
3) login time
4) logout time
5) name of accessed schema

writing this trigger and creating the table that will hold the required data.

View 6 Replies View Related

Forms :: Copy Rows From Excel And Paste In 6i Program?

Sep 28, 2007

I want to copy some rows in one column from Excel and Paste it in a Oracle Forms Progam. Normaly with the clipboard. But my Oracle Forms 6i Program copy alle the rows in one Field, separated with a | character. But I need it in several rows.

View 12 Replies View Related

Forms :: ORA-06508 - PL/SQL - Could Not Find Program Unit Being Called

Feb 18, 2010

Actually what happens is that we are connected to oracle through forms 6i. suddenly we receive the error " ORA-06508: PL/SQL: could not find program unit being called "

while doing some transaction. we have searched on net and meta link. they say that the package / procedure called has become invalid or recompilation has occurred and that is not compatible. Now we have monitored carefully that there are no changes what so ever has been made in the the package/ procedure.

what could be the reason behind this. we have also checked the global variable issue. we use package level variables but declared in the package body only. (so these are not public)

View 20 Replies View Related







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