Search results for query: *

The dropjava utility reverses the action of loadjava. It converts filenames into the names of schema objects, drops the schema objects, and finally deletes their digest table rows. Dropping a class invalidates classes that depend on it directly or indirectly. Dropping a source also drops classes...

hi, use Out_1 = comm("Output") instead. fmsousa

Assume you have a procedure like this one below, and that it has been already created on the Oracle database. This procedure doesn't return anything, but that doesn't change anything! STEP #1: /******STORED PROCEDURE ON ORACLE DATABASE************/...

your code shoud stay like this: CREATE OR REPLACE PROCEDURE sp_adduser (pid IN contact.person_id%TYPE, email IN contact.e_mail%TYPE, pass IN contact.PASSWORD%TYPE, ret OUT NUMBER ) AS cnt NUMBER; procedure_error EXCEPTION; BEGIN SELECT COUNT(*) INTO cnt FROM contact; IF cnt > 0...

with: drop procedure proc_XXXX; i don´t receive any error, but i wait more than 15 minutes and nothing... (time out)

Hi there! I cannot drop a procedure. I think there is a problem with data dictionary and this object (procedure). Can u tell me if there is any package that drop procedures that cannot been dropped normaly? Thanks in advance, Fernando Sousa

Hi, I have 4 items in a listbox. I would like to know if 1 of this 4 items is selected. How can i do this. Please it's very urgent. Thanks in advance.

Hi, does anyone know about problems reading a big size file in a procedure pl/sql, using Oracle package UTL_FILE? Thanks in advance,

Hi, I'm trying to write a servlet that get it's JDBC drivers from another class. My problem is that one of the drivers causes a "ClassFormatError: Illegal constant pool type" error. Can anyone help me? Thanks in advance...

Hi, I would like to know how can i create a trigger disabled. If i do like this: CREATE TRIGGER xpto... it stays enabled. there is any possibility of creating directly a trigger at disabled mode? Thanks in advance!

Hi, I would like to know how can i create a trigger disabled. If i do like this: CREATE TRIGGER xpto... it stays enabled. there is any possibility of creating directly a trigger at disabled mode. Thanks in advance!

Hi, I would like to know how can i create a trigger disabled. If i do like this: CREATE TRIGGER xpto... it stay enabled. there is any possibility of creating directly a trigger at disabled mode. Thanks in advance!

Hi, How can i insert only numeric values into a text items?! At VB we had a trigger(event) called when-key-pressed and then we could get key code ascii. Thanks in Advance!

Hi, I have 2 blocks (1 non base table and another that is base table). The first block has got only 1 text item and a button. The 2nd block (base table) has got 3 text items (tabular type with 8 rows each one). The Problem: i wrote a value into the text item (char) from the 1st block and then...

Hi, I have 2 blocks (1 non base table and another that is base table). The first block has got only 1 text item and a button. The 2nd block (base table) has got 3 text items (tabular type with 8 rows each one). The Problem: i wrote a value into the text item (char) from the 1st block and then...

i'm using Forms Developer and i want to call a file that is in a UNIX Server. I have used the following instruction: UTL_FILE.FOPEN ('/path','filename','r') but nothing.... Can u help me? Thanks in advance.

No, i'm using Forms Developer and i want to call a file that is in a UNIX Server. I have used the following instruction: UTL_FILE.FOPEN ('/path','filename','r') but nothing.... Can u help me? Thanks in advance.

Hi, I would like to know how can i execute a file that is under UNIX system, without using @path/file.sql I used this package UTL_FILE.FOPEN but i haven't got any results... Please if u know one way to do this, it would be great!! Thanks in advance.

Hi, In a form, i have a button that would create a new user. this button has got the following code: create_user (:user_name, :user_password, :user_database); ... ... in this procedure i put the following code to create the new user: CREATE OR REPLACE PROCEDURE CREATE_USER (user_name IN...

Hi, In a form, i have a button that would create a new user. this button has got the following code: create_user (:user_name, :user_password, :user_database); ... ... in this procedure i put the following code to create the new user: CREATE OR REPLACE PROCEDURE CREATE_USER (user_name IN...