Emmet McGovern wrote:
> I'm looking for some recommendations on 3rd party monitoring services. I
> need the ability to monitor multiple ports and a good reporting display.
> The ability to phone home is a plus.
This doesn't work for me....
<cfquery datasource="ADSPRD_blogcfm" name="qry1">
CREATE OR REPLACE FUNCTION year (MyDate DATE) RETURN NUMBER AS BEGIN
RETURN extract(YEAR FROM MyDate);
END year;
</cfquery>
<cfquery name="qry2" datasource="ADSPRD_blogcfm">
SELECT year(SYSDATE) FROM DUAL
</cfquery>
<cfdump var="#qry2#">
The user I'm connecting with has dba privileges, and is able to do this
via SQL Plus.
I verified that the datasource settings allow CREATE statements.
The error, which occurs on qry2, is:
[Macromedia][Oracle JDBC Driver][Oracle]ORA-06575: Package or function
YEAR is in an invalid state
I might also add that no matter what I do, I can't get qry1 to return an
error. I actually had "IS" instead of "AS" and it still generated no error.
- rIck
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192928
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
