This content has been marked as final. Show 9 replies
It probably won't allow you to post your code because there is something in there that the forum software thinks is a naughty word - this crops up quite a bit. Try looking at it very carefully to guess what the offending word / sequence of letters might be or just rename all your parameters variables etc...
Jay wrote:It could be that your code contains some words that aren't permitted on the forums. If it contains certain words that spammers use a lot e.g. "S h o e s" then it may be rejected by the forum on the belief that you're trying to post spam.
First of all, whenever i try and put my attempted code for this in a thread it says 'sorry content not allowed'.
Here's a simple function, and a test of it:
CREATE OR REPLACE FUNCTION hello ( in_txt IN VARCHAR2 ) RETURN VARCHAR2 DETERMINISTIC IS return_txt VARCHAR2 (100); -- Value to be returned BEGIN return_txt := 'Hello, ' || in_txt || '!'; RETURN return_txt; END hello ; / SHOW ERRORS SELECT dname , hello (dname) AS hello_results FROM scott.dept ;
I don't know why you can't post your function. Here's how you can find out:
Function created. No errors. DNAME HELLO_RESULTS -------------- ------------------------------ ACCOUNTING Hello, ACCOUNTING! RESEARCH Hello, RESEARCH! SALES Hello, SALES! OPERATIONS Hello, OPERATIONS!
First, change the subject line of your first message to something like "IN PROGRESS - Please Do Not Reply Yet".
Copy the hello function I posted into your text editor
Reply to this message, and post your copy of the function.
Did you get the error again? If so, it looks like there's some security feature on your system that's keeping you from posting code.
If you can post my function exactly as it is, then change it a little. Update your latest message, a little bit at a time, to make the function more and more like your function. For example, just change the name of the function to your actual function name. Change the message. If it posts corretly, make another small change, until you get the "content not allowed" message. If you can't figure out what's causing it, then change the subject line back to something meaningful, change the last message back to the last version that did post correctly, and describe what you changed that caused the error.
You can use SQL*Plus to create and test the function. Write a script (that is, a text file), similar to the one I posted above. If you name the file hello.sql, then you can run the script from the "SQL> " prompt by saying
using the full path name on your system where I used "c:\fubar\sql" above.
Edited by: Frank Kulash on Dec 8, 2010 9:18 AM