Parameters of an Oracle stored procedure
I'm using PowerBuilder 9.0 with Oracle Net8.
Is it possible to make parameters of an Oracle stored
into bind variables? Thanks.
...How to convert Sql Server Stored Procedures into Oracle Stored Procedures
Hi All, I am migrating from sql server2000 to oracle. I have moved all table into oracle manually. Now I need to move stored procedure. I don't know how to convert sql server stored procedure into oracle stored procedure form. Is there any tool which will convert directly. Please some one help me.
Hi there,Please use the tool bellow, which does the job you want. http://www.swissql.com/products/sqlserver-to-oracle/sql-server-to-oracle.html thanks sharp guy...Oracle stored procedure with BLOB parameter
I have two simple Oracle7 stored procedures that will store LONG RAW
into and retrieve from an Oracle table.
They are declared as transaction object's local external function -
put_raw( long id, BLOB b, REF int returncode) and
get_raw(long id, REF BLOB b, REF int returncode)
The problem I am having is that put_raw() works just fine.
Get_raw() seems to work, and to verify , I write the BLOB variable
into a file.
It is supposed to be a JPG file, but the written file is not a JPG.
Secondly, before invoking get_raw(), I must do:
b = BLOB(space(32000))
...Binding parameters of an Oracle stored procedure
I'm using PowerBuilder 9.0 and Oracle Net8.
When a DBParm parameter DisableBind is set to 0(default),
PowerBuilder binds input parameters to a compiled SQL
I wonder if this applies to parameters of an Oracle stored
Since you don't put a : on the arguments to an RPCFUNC, I don't think so.
<Nobuo Saito> wrote in message news:firstname.lastname@example.org...
> I'm using PowerBuilder 9.0 and Oracle Net8.
> When a DBParm parameter DisableBind is set to 0(default),
> PowerBuilder binds input parameters to a compiled SQL...Oracle Output Parameters from Stored Procedure
Powerbuilder 8.0 Executable compiled in Windows 2000 is causing GPF while
executing on Windows NT workstation. This problem is occurring frequently while
accessing the application from windows NT workstation and same one is working
perfectly in windows 2000 workstation.
After investigating the GPF we found out that this problem is occuring while
executing the stored procedure with more than 20 parameters from powerbuilder
executable on windows NT workstation. The same part of the code is executing
successfully on windows 2000 workstation. we are suspecting that the problem is
occuring...Variable number of parameters into stored procedure
I apologize up front for the length of this message.
I am trying to pass a variable number of parameters into a MS SQL 2008
stored procedure using Delphi 2009.
The procedure (and stored procedure) are:
procedure AddTagToPartID(PartID : Integer; Tag, TagDescription : String;
CreateNew : Boolean;
TagCodeGUID : TGUID;
NewTagCode : String;
AssignRelated : Boolean; RelatedTagGUID : TGUID);
RS : TADOStoredProc;
RS := TADOStoredProc.Create(nil);
RS.Connection ...Array parameter to oracle stored procedure
I want to pass array parameter to following oracle stored procedure from visual studio 2005 using vb.net my is question is it possible or not
create or replace package demo_pkg as type charArray is table of varchar2(255) index by binary_integer; procedure emp_report( pin in charArray, &nb...Mobilink Parameters not passed to some stored procedures
We are working in a MS SQL Server 200 - Adaptive Server Anywhere MobiLink
Version 184.108.40.2069 environment.
When I define a download_cursor script which calls a stored procedure, and
want to pass along the ml_user parameter, Mobilink does not pass this
(I use the -zd command-line option to pass the last download timestamp last)
(This was already an issue in version 7.0.x. We then used a workaround which
greatly complicated our synchronization scripts)
MOBILINK LOG EXTRACT
E. 06/25 16:44:00. <1.5> [B1]: Error: ODBC: [Mic...Oracle: No stored procedure parameters during design.
I have a simple test stored procedure. I setup a TAdoStoredProcedure and a TAdoDataSet to call the procedure. I set the name (The name is present in the drop down.), but no parameters show up after setting the name procedure's name. What is missing here? Here is the procedure's code.
create or replace PROCEDURE ns_foo(
aInt1 in INTEGER,
aInt2 in INTEGER,
aResult out INTEGER)
aResult := aInt1 + aInt2;
My database is a local database with Oracle 10g Express.
I think I might have found the problem. I created a new user and created the objects in the ...How to use Oracle Store Procedure with out parameters?
Could you give me a hand to let me go out of my problem? I create a package
acc.MS_Load.remove_(info_ out varchar2, contract_ in varchar2), then I
using the following script to use it as that:
string info_, contract_
info_ = space(2000)
contract = 'NN'
DECLARE myproc procedure for acc.MS_load.remove_(:info_,:contract_);
if sqlca.sqlcode ....
When it runs, it said that "PLS-00306:wrong numnber or types of arguments
in call to 'acc.ms_load.remove_'"
Thank you and best regards!
Try using INOUT instead...SQLAnywhere stored procedure output parameters?
Is there any way to get the value of output parameters for stored
procedures in SQL Anywhere in PowerBuilder? I know the output parameters
are supported by the DBMS, because I can get their values in Delphi.
Thanks in advance.
Thanks. I wish I could do something like DECLARE PROCEDURE... with the OUT
specifier. Also I need to call stored procedures with output parameters in a
dynamic way. I don't know exactly the name of the stored procedure until
run-time, but I know about the number of arguments and their types. Is it
possible? (Not only for...Stored Procedure
I have a repeater control which I populate with search results from SQL Server.
But I can't figure out how to cope with users who submit multiple search items and still use my stored procedure. Is this possible or do you have to build the query with a StringBuilder and execute it manually?
I'm using a stored procedure with parameters:
input parameters <-- PageSize & CurrentPage
output parameter --> TotalRecords
Am using a temporary table to store all records before Select-ing those required for the particular page.
If I compose the query manually then I ...Call Oracle Store Procedure with cursor parameter
I have a problem when call the Oracle Store Procedure from Powerbuilder.
The Store Procedure should pass a cursor parameter.
How can I pass the cursor from Powerbuilder.
The working environment is PB7 and Oracle 8i
Thanks a lot
---== Posted via the PFCGuide Web Newsreader ==---
you will have to create a package like this:
package pkg_rpt_set is
type my_result_set is REF CURSOR ;
end pkg_rpt_set ;
Then your procedure should be like :
PROCEDURE p_test (p_user_id varchar2,
out_result ...Stored Procedure (without parameters) vs. Oracle
in our company we are using many (small) PowerBuilder
applications. Currently we are migrating some of these to
PowerBuilder 10.2. The migration itself (in terms of getting
applications compile with PB 10.2) seems to be pretty easy.
there is a problem with one particular PB 6.5 app. This
calls a stored procedure in our Oracle 220.127.116.11 database. The
stored procedure is pretty simple and takes no parameters.
using PB 6.5 with the native O73 driver it works, but if I
try to run
the application with PB 10.2 and the native O84 driver, the