Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2008
    Location
    Midrand, South Africa
    Posts
    22

    Unanswered: apex wwv_flow.show

    I am attempting to create a table with the following sql.
    Code:
    CREATE TABLE MEMBERS
    (
      MEM_NUMBER           VARCHAR2(12 BYTE) CONSTRAINT MEM_NUMBER_NN NOT NULL,
      MEM_SNAME            VARCHAR2(25 BYTE),
      MEM_FNAME            VARCHAR2(25 BYTE),
      MEM_ANAME            VARCHAR2(25 BYTE),
      MEM_TITLE            VARCHAR2(25 BYTE),
      MEM_IDTYPE           NUMBER(5),
      MEM_IDREF            VARCHAR2(120 BYTE),
      MEM_DATE_IDISS       DATE,
      MEM_ADD1             VARCHAR2(60 BYTE),
      MEM_ADD2             VARCHAR2(60 BYTE),
      MEM_ADD3             VARCHAR2(60 BYTE),
      MEM_ADD4             VARCHAR2(60 BYTE),
      MEM_PCODE            VARCHAR2(12 BYTE),
      MEM_PHONE            VARCHAR2(20 BYTE),
      MEM_DREG             DATE,
      MEM_TREG             DATE,
      MEM_DLAST            DATE,
      MEM_DBIRTH           DATE,
      MEM_DOBON            NUMBER(1) CONSTRAINT MEM_DOBON_NN NOT NULL,
      MEM_POST             NUMBER(1) CONSTRAINT MEM_POST_NN NOT NULL,
      MEM_NEW              NUMBER(1) CONSTRAINT MEM_NEW_NN NOT NULL,
      MEM_BARRED           NUMBER(1) CONSTRAINT MEM_BARRED_NN NOT NULL,
      MEM_SEX              NUMBER(5),
      MEM_BDAY             NUMBER(5),
      MEM_BMONTH           NUMBER(5),
      MEM_BYEAR            NUMBER(5),
      MEM_ANAL01           NUMBER(5),
      MEM_ANAL02           NUMBER(5),
      MEM_ANAL03           NUMBER(5),
      MEM_ANAL04           NUMBER(5),
      MEM_ANAL05           NUMBER(5),
      MEM_ANAL06           NUMBER(5),
      MEM_ANAL07           NUMBER(5),
      MEM_ANAL08           NUMBER(5),
      MEM_ANAL09           NUMBER(5),
      MEM_ANAL10           NUMBER(5),
      MEM_CARDNO           VARCHAR2(22 BYTE),
      MEM_FACE             NUMBER(10),
      MEM_ID               NUMBER(10),
      MEM_ENTRY            NUMBER(1) CONSTRAINT MEM_ENTRY_NN NOT NULL,
      MEM_CARD1            VARCHAR2(22 BYTE),
      MEM_TYPE1            VARCHAR2(4 BYTE),
      MEM_COLOUR           NUMBER(10),
      MEM_NAMEDAY          NUMBER(5),
      MEM_NAMEMONTH        NUMBER(5),
      MEM_ANIVDAY          NUMBER(5),
      MEM_ANIVMONTH        NUMBER(5),
      MEM_ANIVYEAR         NUMBER(5),
      MEM_NAMESPECIAL      VARCHAR2(4 BYTE),
      MEM_ITGNO            VARCHAR2(12 BYTE),
      MEM_GDREG            DATE,
      MEM_ENTERED_BY       VARCHAR2(16 BYTE),
      MEM_LAST_UPDATE_BY   VARCHAR2(16 BYTE),
      MEM_SIG              NUMBER(10),
      MEM_NO_GRAD          NUMBER(1) CONSTRAINT MEM_NO_GRAD_NN NOT NULL,
      MEM_FREE_PARK        NUMBER(1)                DEFAULT 0 CONSTRAINT MEM_FREE_PARK_NN NOT NULL,
      MEM_STATUS           VARCHAR2(9 BYTE)         DEFAULT 1                     NOT NULL,
      MEM_AUTH_STFF_CRDNO  VARCHAR2(12 BYTE),
      MEM_BARCODE          VARCHAR2(37 BYTE),
      MEM_BADGE_NUMBER     NUMBER(16),
      MEM_GRPADDR_NAME     VARCHAR2(50 BYTE),
      MEM_DISP_NAME        VARCHAR2(25 BYTE),
      MEM_DIST_FRM_CASINO  NUMBER(24,4),
      MEM_GEO_CODE         NUMBER(5)
    )
    and the response I get from Apex is:-
    The requested URL /apex/wwv_flow.show was not found on this server

    Please tell me what I am missing.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    If I were you, I'd run that statement in SQL*Plus.

  3. #3
    Join Date
    Oct 2008
    Location
    Midrand, South Africa
    Posts
    22

    apex wwv_flow.show

    It works fine in sqlplus but thanks for the suggestion.
    Apex appears to have a buffer size limit.

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Apex will have a buffer size limit, but I'd be surprised if it was that low (less than 3000 characters). In fact, I just ran your create table statement via the SQL Commands window in Apex 3.2 and it worked fine.

    I just found this post that could be relevant I suppose.

  5. #5
    Join Date
    Oct 2008
    Location
    Midrand, South Africa
    Posts
    22
    Thank you.

Posting Permissions

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