Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. fmsousa

    Java Stored Procedures

    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...
  2. fmsousa

    ASP call a stored procedure

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

    ASP call a stored procedure

    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************/...
  4. fmsousa

    PL/SQL question

    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...
  5. fmsousa

    Can´t Drop Procedure

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

    Can´t Drop Procedure

    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
  7. fmsousa

    VERY URGENT: listbox item is selected?!

    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.
  8. fmsousa

    UTL_FILE problems

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

    ClassLoader

    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...
  10. fmsousa

    CREATE A DISABLED TRIGGER

    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!
  11. fmsousa

    CREATE A DISABLED TRIGGER

    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!
  12. fmsousa

    CREATE TRIGGER DISABLED - URGENT!

    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!
  13. fmsousa

    Oracle Forms - Only numeric values

    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!
  14. fmsousa

    Oracle Forms - Non Base Table / Base Table

    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...
  15. fmsousa

    Oracle Forms

    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...
  16. fmsousa

    Execute a File at UNIX Server using Forms

    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.
  17. fmsousa

    File at UNIX Server

    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.
  18. fmsousa

    File at UNIX Server

    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.
  19. fmsousa

    CREATE USER ?!

    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...
  20. fmsousa

    Create User in a Stored Procedure

    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...

Part and Inventory Search

Back
Top