creating dynamic table in oracle

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default creating dynamic table in oracle

    Here is the bit causing problems:

    create table tempTAble (case_id) as
    SELECT case_id from feedback where feedback.status=1

    Its giveing me the follwing error
    Oracle JDBC Driver]ORA-01027: bind variables not allowed for data definition
    operations

    the query perfectly works in TOAD, is there any limitation on creating dynamic
    tables using CF

    thanks
    kishore





    kishoreb Guest

  2. Similar Questions and Discussions

    1. Creating an Oracle Datasource
      I am trying to create an Oracle Datasource under CF MX7 Standard Edition. I selected other and used the JDBC URL and Driver Class of: ...
    2. Oracle Table Access With Oracle OLEDB Driver
      If I use the Oracle client to access the Oracle database with DW 2004, it does not display any tables. If I use the Microsoft client it does work. ...
    3. creating a dynamic table with subcategories
      Hello, I am trying to organize videos by date and category. I want it to look like this: June 9th 2004 Animals -funny cat on roof - dog...
    4. How to create a table with dynamic table name
      <html><div style='background-color:'><DIV> <DIV class=Section1> <P class=MsoNormal style="mso-layout-grid-align: none"><FONT face="Times New Roman"...
    5. Dynamic Table with Dynamic LinkButtons
      Looks like I'm not the only one to come across this. Found a post 9 months old that deals with the same thing. Here's the fix: Add line:...
  3. #2

    Default Re: creating dynamic table in oracle

    Just do this:
    create table tempTAble as
    SELECT case_id from feedback where feedback.status=1

    CF_Oracle Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139