Coldfusion-Oracle functions-URGENT

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

  1. #1

    Default Coldfusion-Oracle functions-URGENT

    I have a cfm file which calls Oracle functions. Now, I updated the Oracle
    function and try running the cfm file again[from apache], but i cannot see my
    updated values in the page. Do I need to do anything else ? when i try
    running in the query from oracle client I can see the changes and the values
    updated. Why is cfm not seeing the changes ? I call the cfmquery like this:
    <cfquery name='test' datasource='test'> select testFn(name) as
    test1 from test; </cfquery> Now, this testFn is already existing and its
    running also. Now, I have to make some changes to the existing function and
    when i made the changes, the changes r not getting reflected in the output. my
    datasource is registered in admin. Please help :confused;

    12345rgr Guest

  2. Similar Questions and Discussions

    1. Server is tasked at 100% - Coldfusion 5 Urgent
      Hello, We are running cf 5.0,0,0 server on Windows 2000 server. All of a sudden it is starting to task out at 100%. We are running 30+ datasources...
    2. Coldfusion Functions
      Sorry if I have posted this incorrectly. Fairly new to this site. My question: Is it possible to trigger the AddDate function with the onfocus...
    3. Urgent help needed! Compare a string to Sysdate in Oracle
      I am trying to write a simple SQL statement which will take a string (startdate) in the format DDMMYYYY and compare it to a date stored in an...
    4. Oracle BAckup Failed. Urgent Please
      Hi gurus, I'm facing this problem where I'm trying to backup using BAckup tool in Oracle EM and it says file already exists. Can you please look...
    5. Temporary tablespace near 100% full, smon is not freeing up, Oracle 7.3.4.5 ----> URGENT
      Oracle does not free up the segments in a temporary tablespace because it is a waste of resources. The next sort needs to allocate it again. In...
  3. #2

    Default Re: Coldfusion-Oracle functions-URGENT

    Can we see the cfm code that invokes the db function?

    javabuzz Guest

  4. #3

    Default Re: Coldfusion-Oracle functions-URGENT

    Sounds like the old function is being cached somewhere and that's what ColdFusion is using.
    jdeline 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