stored procedure in delphi with oracle

100 pts.
Tags:
Delphi
Delphi 5.0
Oracle
Oracle stored procedures
Stored Procedures
how to match the datatype of the field that is in database and the datatype of the variable that holds the value of the returned value from database using stored procedure.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Are you having some specific problem matching some datatypes ?
In general, data types from the database won’t be the same as the data types from Delphi, but you should use some similar data types (for example, a String delphi data type for a varchar2 oracle data type).

You will probably need to read the documentation from both (delphi and oracle) to see what type of data can store each data type, so you know how to match them.

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • VPL
    thanks a lot ! i'm using string datatype for varchar2 oracle datatype. Actually what i have done here is, i pass string and date variables to stored procedure. but am getting the error as 'no parameter type for parameter start_day'. Where start_day is the string parameter. I think i need to check with stored procedure in oracle. how can I check the stored procedure?? whether i need to install any software for this?? I'm not aware of using stored procedure with oracle in delphi. Please help out on this. Thanks in Advance.
    100 pointsBadges:
    report
  • VPL
    one more question : From where I can read the documentation for both (delphi and oracle) to see what type of data can store each data type ???
    100 pointsBadges:
    report
  • carlosdl
    Could you please paste your code here ? By the error message, I don't think the problem is due to a datatype mismatch. I guess you have oracle client software installed, so you can check the stored procedure from SQL*Plus. To see the procedure signature use: describe <stored procedure name>; To run the stored procedure use: execute <stored procedure name> ( <parameters>); Check these links for oracle data types documentation: Oracle® Database Concepts 10g Release 1 (10.1) - Native Data Types Oracle® Database Concepts 11g Release 1 (11.1) - Oracle Data Types Some Delphi information about data types can be found in the following link: Delphi data types Regards,
    69,510 pointsBadges:
    report
  • VPL
    hI, I tried to view the procedure using sql plus for oracle 9. but i got 'object does not exist' error. Does it mean there is no stored procedure in oracle?? is there any way to view the all stored procedure that are in a oracle database??
    100 pointsBadges:
    report
  • Apickel
    select text from all_source where object_type='PROCEDURE' and name='<put your procedure name in caps here>' where owner='<put owner of the procedure here in caps>' This is select statement that would be run from client software capable of executing sql (e.g., sql*plus). Keep in mind, you have to have been granted rights to query the all_source view. If you are logged in to the database with your user id and you know the procedure belongs to you (i.e., you are the owner) then you could change the view name in the query to user_source and omit the "owner =" clause of the query.
    350 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following