How i can execute function?
SQL code work in Oracle SQL Developer, but not work in PHP PDO
example:
$sql = <<<SQL
var sss varchar2(1000);
begin
:sss := AFACE_WWW_PNAL_SAVE(
54687,
10.66,
'Description'
);
end;
SQL;
$pdo->prepare($sql);
$pdo->query($sql); -- Exception
Error: SQLSTATE[HY000]: General error: 900 OCIStmtExecute: ORA-00900: invalid SQL statement
How i can get result in "sss" variable?
sql oracle pdo
add a comment |
SQL code work in Oracle SQL Developer, but not work in PHP PDO
example:
$sql = <<<SQL
var sss varchar2(1000);
begin
:sss := AFACE_WWW_PNAL_SAVE(
54687,
10.66,
'Description'
);
end;
SQL;
$pdo->prepare($sql);
$pdo->query($sql); -- Exception
Error: SQLSTATE[HY000]: General error: 900 OCIStmtExecute: ORA-00900: invalid SQL statement
How i can get result in "sss" variable?
sql oracle pdo
1
var[iable]
is a SQL Developer (and SQL*Plus/SQLcl) client-specific declaration of a bind variable. It is not part of the SQL, or even PL/SQL, language.
– Alex Poole
Dec 29 '18 at 9:58
add a comment |
SQL code work in Oracle SQL Developer, but not work in PHP PDO
example:
$sql = <<<SQL
var sss varchar2(1000);
begin
:sss := AFACE_WWW_PNAL_SAVE(
54687,
10.66,
'Description'
);
end;
SQL;
$pdo->prepare($sql);
$pdo->query($sql); -- Exception
Error: SQLSTATE[HY000]: General error: 900 OCIStmtExecute: ORA-00900: invalid SQL statement
How i can get result in "sss" variable?
sql oracle pdo
SQL code work in Oracle SQL Developer, but not work in PHP PDO
example:
$sql = <<<SQL
var sss varchar2(1000);
begin
:sss := AFACE_WWW_PNAL_SAVE(
54687,
10.66,
'Description'
);
end;
SQL;
$pdo->prepare($sql);
$pdo->query($sql); -- Exception
Error: SQLSTATE[HY000]: General error: 900 OCIStmtExecute: ORA-00900: invalid SQL statement
How i can get result in "sss" variable?
sql oracle pdo
sql oracle pdo
edited Dec 31 '18 at 0:43
sticky bit
14.1k81632
14.1k81632
asked Dec 29 '18 at 6:04
JohnJohn
143
143
1
var[iable]
is a SQL Developer (and SQL*Plus/SQLcl) client-specific declaration of a bind variable. It is not part of the SQL, or even PL/SQL, language.
– Alex Poole
Dec 29 '18 at 9:58
add a comment |
1
var[iable]
is a SQL Developer (and SQL*Plus/SQLcl) client-specific declaration of a bind variable. It is not part of the SQL, or even PL/SQL, language.
– Alex Poole
Dec 29 '18 at 9:58
1
1
var[iable]
is a SQL Developer (and SQL*Plus/SQLcl) client-specific declaration of a bind variable. It is not part of the SQL, or even PL/SQL, language.– Alex Poole
Dec 29 '18 at 9:58
var[iable]
is a SQL Developer (and SQL*Plus/SQLcl) client-specific declaration of a bind variable. It is not part of the SQL, or even PL/SQL, language.– Alex Poole
Dec 29 '18 at 9:58
add a comment |
1 Answer
1
active
oldest
votes
I don't know if PL/SQL blocks are even allowed there, but if they are you may miss a DECLARE
at the beginning.
But you don't need PL/SQL to get a value from a function. You can query dual
.
SELECT aface_www_pnal_save(54687, 10.66, 'Description') sss
FROM dual;
Then i can next Exception:SQLSTATE[HY000]: General error: 14552 OCIStmtExecute: ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
– John
Jan 5 at 2:48
@John: Please edit your question and include the definition of the function.
– sticky bit
Jan 5 at 2:50
for example (community.oracle.com/thread/589982)
– John
Jan 5 at 3:14
@John: Having DML or DML orCOMMIT
orROLLBACK
in a function is not good at all. I strongly suggest, that you don't do that. Besides that, try thePRAGMA AUTONOMOUS_TRANSACTION
as suggested in the Oracle forum.
– sticky bit
Jan 5 at 3:21
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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%2fstackoverflow.com%2fquestions%2f53967136%2fhow-i-can-execute-function%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
I don't know if PL/SQL blocks are even allowed there, but if they are you may miss a DECLARE
at the beginning.
But you don't need PL/SQL to get a value from a function. You can query dual
.
SELECT aface_www_pnal_save(54687, 10.66, 'Description') sss
FROM dual;
Then i can next Exception:SQLSTATE[HY000]: General error: 14552 OCIStmtExecute: ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
– John
Jan 5 at 2:48
@John: Please edit your question and include the definition of the function.
– sticky bit
Jan 5 at 2:50
for example (community.oracle.com/thread/589982)
– John
Jan 5 at 3:14
@John: Having DML or DML orCOMMIT
orROLLBACK
in a function is not good at all. I strongly suggest, that you don't do that. Besides that, try thePRAGMA AUTONOMOUS_TRANSACTION
as suggested in the Oracle forum.
– sticky bit
Jan 5 at 3:21
add a comment |
I don't know if PL/SQL blocks are even allowed there, but if they are you may miss a DECLARE
at the beginning.
But you don't need PL/SQL to get a value from a function. You can query dual
.
SELECT aface_www_pnal_save(54687, 10.66, 'Description') sss
FROM dual;
Then i can next Exception:SQLSTATE[HY000]: General error: 14552 OCIStmtExecute: ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
– John
Jan 5 at 2:48
@John: Please edit your question and include the definition of the function.
– sticky bit
Jan 5 at 2:50
for example (community.oracle.com/thread/589982)
– John
Jan 5 at 3:14
@John: Having DML or DML orCOMMIT
orROLLBACK
in a function is not good at all. I strongly suggest, that you don't do that. Besides that, try thePRAGMA AUTONOMOUS_TRANSACTION
as suggested in the Oracle forum.
– sticky bit
Jan 5 at 3:21
add a comment |
I don't know if PL/SQL blocks are even allowed there, but if they are you may miss a DECLARE
at the beginning.
But you don't need PL/SQL to get a value from a function. You can query dual
.
SELECT aface_www_pnal_save(54687, 10.66, 'Description') sss
FROM dual;
I don't know if PL/SQL blocks are even allowed there, but if they are you may miss a DECLARE
at the beginning.
But you don't need PL/SQL to get a value from a function. You can query dual
.
SELECT aface_www_pnal_save(54687, 10.66, 'Description') sss
FROM dual;
answered Dec 29 '18 at 7:42
sticky bitsticky bit
14.1k81632
14.1k81632
Then i can next Exception:SQLSTATE[HY000]: General error: 14552 OCIStmtExecute: ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
– John
Jan 5 at 2:48
@John: Please edit your question and include the definition of the function.
– sticky bit
Jan 5 at 2:50
for example (community.oracle.com/thread/589982)
– John
Jan 5 at 3:14
@John: Having DML or DML orCOMMIT
orROLLBACK
in a function is not good at all. I strongly suggest, that you don't do that. Besides that, try thePRAGMA AUTONOMOUS_TRANSACTION
as suggested in the Oracle forum.
– sticky bit
Jan 5 at 3:21
add a comment |
Then i can next Exception:SQLSTATE[HY000]: General error: 14552 OCIStmtExecute: ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
– John
Jan 5 at 2:48
@John: Please edit your question and include the definition of the function.
– sticky bit
Jan 5 at 2:50
for example (community.oracle.com/thread/589982)
– John
Jan 5 at 3:14
@John: Having DML or DML orCOMMIT
orROLLBACK
in a function is not good at all. I strongly suggest, that you don't do that. Besides that, try thePRAGMA AUTONOMOUS_TRANSACTION
as suggested in the Oracle forum.
– sticky bit
Jan 5 at 3:21
Then i can next Exception:
SQLSTATE[HY000]: General error: 14552 OCIStmtExecute: ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
– John
Jan 5 at 2:48
Then i can next Exception:
SQLSTATE[HY000]: General error: 14552 OCIStmtExecute: ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
– John
Jan 5 at 2:48
@John: Please edit your question and include the definition of the function.
– sticky bit
Jan 5 at 2:50
@John: Please edit your question and include the definition of the function.
– sticky bit
Jan 5 at 2:50
for example (community.oracle.com/thread/589982)
– John
Jan 5 at 3:14
for example (community.oracle.com/thread/589982)
– John
Jan 5 at 3:14
@John: Having DML or DML or
COMMIT
or ROLLBACK
in a function is not good at all. I strongly suggest, that you don't do that. Besides that, try the PRAGMA AUTONOMOUS_TRANSACTION
as suggested in the Oracle forum.– sticky bit
Jan 5 at 3:21
@John: Having DML or DML or
COMMIT
or ROLLBACK
in a function is not good at all. I strongly suggest, that you don't do that. Besides that, try the PRAGMA AUTONOMOUS_TRANSACTION
as suggested in the Oracle forum.– sticky bit
Jan 5 at 3:21
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53967136%2fhow-i-can-execute-function%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
1
var[iable]
is a SQL Developer (and SQL*Plus/SQLcl) client-specific declaration of a bind variable. It is not part of the SQL, or even PL/SQL, language.– Alex Poole
Dec 29 '18 at 9:58