Call to Function in Oracle says it's not declaredstored procedure returns ERROR 1305 (42000): FUNCTION does...
Is there a data structure that only stores hash codes and not the actual objects?
Why do Australian milk farmers need to protest supermarkets' milk price?
Is a party consisting of only a bard, a cleric, and a warlock functional long-term?
Why do passenger jet manufacturers design their planes with stall prevention systems?
Are all passive ability checks floors for active ability checks?
How to change two letters closest to a string and one letter immediately after a string using notepad++
In a future war, an old lady is trying to raise a boy but one of the weapons has made everyone deaf
How Could an Airship Be Repaired Mid-Flight
Do I need life insurance if I can cover my own funeral costs?
Can I use USB data pins as power source
How to deal with a cynical class?
Why one should not leave fingerprints on bulbs and plugs?
What approach do we need to follow for projects without a test environment?
How difficult is it to simply disable/disengage the MCAS on Boeing 737 Max 8 & 9 Aircraft?
Did Ender ever learn that he killed Stilson and/or Bonzo?
Who is flying the vertibirds?
Official degrees of earth’s rotation per day
Python if-else code style for reduced code for rounding floats
The difference between「N分で」and「後N分で」
How to write cleanly even if my character uses expletive language?
If I can solve Sudoku can I solve Travelling Salesman Problem(TSP)? If yes, how?
How to create the Curved texte?
A sequence that has integer values for prime indexes only:
Does Mathematica reuse previous computations?
Call to Function in Oracle says it's not declared
stored procedure returns ERROR 1305 (42000): FUNCTION does not existError on Oracle calling external proceduresPackage state not re-intialized on raise_application_errorOracle GoldenGate add trandata errorsHow to raise_application_error beyond a when others clauseHow can I do the following task in OracleEXCEPTION logic is not working in Oracle PL/SQL functionOracle: Get the row count in a cursor when using a OPEN-FOR-USING statementHow to use VARRAY in where clause of a select query in ORACLECustom return type of a function in Oracle PL SQl
When I call the next stored-function in oracle:
CREATE OR REPLACE FUNCTION SOLICITAR_DISPONIBILIDAD (parqueo IN NUMBER, semestre IN NUMBER,
año IN NUMBER, jornada IN NUMBER)
RETURN INTEGER IS
cupo_disponible INTEGER := 0;
cupo_tomado INTEGER := 0;
BEGIN
SELECT capacidad
INTO cupo_disponible
FROM estacionamientos
WHERE numero = parqueo;
SELECT COUNT(*)
INTO cupo_tomado
FROM asignacion_parqueos ap
WHERE ap.par_año = año
AND ap.par_ciclo = semestre
AND ap.par_numero = parqueo
AND ap.par_jornada = jornada;
RETURN cupo_disponible - cupo_tomado;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
RAISE;
END SOLICITAR_DISPONIBILIDAD;
It says 'SOLICITAR_DISPONIBILIDAD' is not a procedure or is undefined. Does anyone knows why?
I call it like this:EXECUTE SOLICITAR_DISPONIBILIDAD(1,0,2014,0);
oracle stored-procedures
asked Oct 11 '14 at 10:52
Chepix10_UrlChepix10_Url
1
bumped to the homepage by Community♦ 4 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
When I call the next stored-function in oracle:
CREATE OR REPLACE FUNCTION SOLICITAR_DISPONIBILIDAD (parqueo IN NUMBER, semestre IN NUMBER,
año IN NUMBER, jornada IN NUMBER)
RETURN INTEGER IS
cupo_disponible INTEGER := 0;
cupo_tomado INTEGER := 0;
BEGIN
SELECT capacidad
INTO cupo_disponible
FROM estacionamientos
WHERE numero = parqueo;
SELECT COUNT(*)
INTO cupo_tomado
FROM asignacion_parqueos ap
WHERE ap.par_año = año
AND ap.par_ciclo = semestre
AND ap.par_numero = parqueo
AND ap.par_jornada = jornada;
RETURN cupo_disponible - cupo_tomado;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
RAISE;
END SOLICITAR_DISPONIBILIDAD;
It says 'SOLICITAR_DISPONIBILIDAD' is not a procedure or is undefined. Does anyone knows why?
I call it like this:EXECUTE SOLICITAR_DISPONIBILIDAD(1,0,2014,0);
oracle stored-procedures
asked Oct 11 '14 at 10:52
Chepix10_UrlChepix10_Url
1
bumped to the homepage by Community♦ 4 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Did it compile without errors? Is your user authorized to call it? Did you try prefixing it with its owner's schema? What's the exact error message?
– Mat
Oct 11 '14 at 12:07
add a comment |
When I call the next stored-function in oracle:
CREATE OR REPLACE FUNCTION SOLICITAR_DISPONIBILIDAD (parqueo IN NUMBER, semestre IN NUMBER,
año IN NUMBER, jornada IN NUMBER)
RETURN INTEGER IS
cupo_disponible INTEGER := 0;
cupo_tomado INTEGER := 0;
BEGIN
SELECT capacidad
INTO cupo_disponible
FROM estacionamientos
WHERE numero = parqueo;
SELECT COUNT(*)
INTO cupo_tomado
FROM asignacion_parqueos ap
WHERE ap.par_año = año
AND ap.par_ciclo = semestre
AND ap.par_numero = parqueo
AND ap.par_jornada = jornada;
RETURN cupo_disponible - cupo_tomado;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
RAISE;
END SOLICITAR_DISPONIBILIDAD;
It says 'SOLICITAR_DISPONIBILIDAD' is not a procedure or is undefined. Does anyone knows why?
I call it like this:EXECUTE SOLICITAR_DISPONIBILIDAD(1,0,2014,0);
oracle stored-procedures
asked Oct 11 '14 at 10:52
Chepix10_UrlChepix10_Url
1
When I call the next stored-function in oracle:
CREATE OR REPLACE FUNCTION SOLICITAR_DISPONIBILIDAD (parqueo IN NUMBER, semestre IN NUMBER,
año IN NUMBER, jornada IN NUMBER)
RETURN INTEGER IS
cupo_disponible INTEGER := 0;
cupo_tomado INTEGER := 0;
BEGIN
SELECT capacidad
INTO cupo_disponible
FROM estacionamientos
WHERE numero = parqueo;
SELECT COUNT(*)
INTO cupo_tomado
FROM asignacion_parqueos ap
WHERE ap.par_año = año
AND ap.par_ciclo = semestre
AND ap.par_numero = parqueo
AND ap.par_jornada = jornada;
RETURN cupo_disponible - cupo_tomado;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
RAISE;
END SOLICITAR_DISPONIBILIDAD;
It says 'SOLICITAR_DISPONIBILIDAD' is not a procedure or is undefined. Does anyone knows why?
I call it like this:EXECUTE SOLICITAR_DISPONIBILIDAD(1,0,2014,0);
oracle stored-procedures
oracle stored-procedures
asked Oct 11 '14 at 10:52
Chepix10_UrlChepix10_Url
1
asked Oct 11 '14 at 10:52
Chepix10_UrlChepix10_Url
1
asked Oct 11 '14 at 10:52
Chepix10_UrlChepix10_Url
1
asked Oct 11 '14 at 10:52
Chepix10_UrlChepix10_Url
1
asked Oct 11 '14 at 10:52
Chepix10_UrlChepix10_Url
1
1
bumped to the homepage by Community♦ 4 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 4 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Did it compile without errors? Is your user authorized to call it? Did you try prefixing it with its owner's schema? What's the exact error message?
– Mat
Oct 11 '14 at 12:07
add a comment |
Did it compile without errors? Is your user authorized to call it? Did you try prefixing it with its owner's schema? What's the exact error message?
– Mat
Oct 11 '14 at 12:07
Did it compile without errors? Is your user authorized to call it? Did you try prefixing it with its owner's schema? What's the exact error message?
– Mat
Oct 11 '14 at 12:07
Did it compile without errors? Is your user authorized to call it? Did you try prefixing it with its owner's schema? What's the exact error message?
– Mat
Oct 11 '14 at 12:07
add a comment |
1 Answer
1
active
oldest
votes
A function has to return something (in your case an INTEGER) somewhere.
Try SELECT SOLICITAR_DISPONIBILIDAD(1,0,2014,0) FROM DUAL
answered Oct 15 '14 at 3:03
GaryGary
1,8091112
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f78958%2fcall-to-function-in-oracle-says-its-not-declared%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
A function has to return something (in your case an INTEGER) somewhere.
Try SELECT SOLICITAR_DISPONIBILIDAD(1,0,2014,0) FROM DUAL
answered Oct 15 '14 at 3:03
GaryGary
1,8091112
add a comment |
A function has to return something (in your case an INTEGER) somewhere.
Try SELECT SOLICITAR_DISPONIBILIDAD(1,0,2014,0) FROM DUAL
answered Oct 15 '14 at 3:03
GaryGary
1,8091112
add a comment |
A function has to return something (in your case an INTEGER) somewhere.
Try SELECT SOLICITAR_DISPONIBILIDAD(1,0,2014,0) FROM DUAL
answered Oct 15 '14 at 3:03
GaryGary
1,8091112
A function has to return something (in your case an INTEGER) somewhere.
Try SELECT SOLICITAR_DISPONIBILIDAD(1,0,2014,0) FROM DUAL
answered Oct 15 '14 at 3:03
GaryGary
1,8091112
answered Oct 15 '14 at 3:03
GaryGary
1,8091112
answered Oct 15 '14 at 3:03
GaryGary
1,8091112
answered Oct 15 '14 at 3:03
GaryGary
1,8091112
1,8091112
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f78958%2fcall-to-function-in-oracle-says-its-not-declared%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Did it compile without errors? Is your user authorized to call it? Did you try prefixing it with its owner's schema? What's the exact error message?
– Mat
Oct 11 '14 at 12:07