How i can execute function?












0















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?










share|improve this question




















  • 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
















0















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?










share|improve this question




















  • 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














0












0








0








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?










share|improve this question
















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






share|improve this question















share|improve this question













share|improve this question




share|improve this question








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














  • 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












1 Answer
1






active

oldest

votes


















5














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;





share|improve this answer
























  • 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 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











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
});


}
});














draft saved

draft discarded


















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









5














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;





share|improve this answer
























  • 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 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
















5














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;





share|improve this answer
























  • 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 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














5












5








5







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;





share|improve this answer













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;






share|improve this answer












share|improve this answer



share|improve this answer










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 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



















  • 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 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

















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


















draft saved

draft discarded




















































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.




draft saved


draft discarded














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





















































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







Popular posts from this blog

Monofisismo

Angular Downloading a file using contenturl with Basic Authentication

Olmecas