Results 1 to 2 of 2

Thread: Function

  1. #1
    Join Date
    Jan 2003
    Posts
    41

    Unanswered: Function

    Hello,

    I need create function which will create table or view or anything else. I use this (see below) syntax but it's not correct:

    CREATE OR REPLACE FUNCTION CREATE_OBJ
    RETURN VARCHAR
    IS
    num NUMBER;
    BEGIN
    CREATE TABLE test (
    id NUMBER
    );
    commit;

    RETURN "OK";
    END;

    Any ideas, please?

    Ondrej

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Function

    See my response to your other post here: http://dbforums.com/t912882.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •