python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - stored-functions

I am getting an error near the end of my function and the only hint is that it is near ''

I've tried reading several other similar answers to this, but none of them as far as I can tell are fixed the same way. I've tried deleting all new lines/tabs to try to remove invisible characters and...
test-img

Justin

mysql

syntax-error

stored-functions

Votes: 0

Answers: 1

Latest Answer

Common "beauty" syntax error. You use ELSE IF - in this case IF is not an alternative branch but separate IF statement. Hence you obtain multiple IF statements without END IF which produces ...
test-img

Akina

How to check if i have the rights to create functions?

So i'm trying to create a stored function but i keep getting this error: Error report - ORA-00604: error occurred at recursive SQL level 1 ORA-20900: No access to modify schema ORA-06512: at line 3 00...
test-img

Dragos Polifronie

oracle

plsql

oracle11g

stored-functions

Votes: 0

Answers: 1

Latest Answer

ORA-20900 (and generally errors between 20000 and 20999) are 'custom' errors, namely, they come from a call to RAISE_APPLICATION_ERROR. Thus this is not a (native) privileges issue. Most likely is tha...
test-img

Connor McDonald

Posts

Questions

Blogs

Jobs