stable simply due to the run time error given during
connection to Oracle DB. However, i would prefer ODBC
due to its stability and consistency of external DB
connectivity.
thanks
--- daniel lim <[EMAIL PROTECTED]> wrote:
> hi,
>
> thx for help, let me try it out.
>
> thx.
>
> daniel
>
> LIVIU STOICA <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> An OciConnection establishes a database connection
> using Oci (Oracle Call Interface).
>
> Within the context of an OciConnection, SQL
> statements are executed and results are returned
>
> Example{ loginProperty LoginProperty = new
> LoginProperty();
> ociConnection ociConnection;
> statement stmt;
> resultSet res;
> ;
> LoginProperty.setServer("ORACLETESTSRV");
> LoginProperty.setDatabase("AXDB");
> LoginProperty.setUsername("TEST");
> LoginProperty.setPassword("TEST_PWD");
>
> try
> {
> ociConnection = new
> ociConnection(LoginProperty);
> }
> catch
> {
> print "Unable to establish connection with
> database";
> return;
> }
>
> stmt = ociConnection.createStatement();
> res = stmt.executeQuery("SELECT empName FROM
> emp");
> while (res.next())
> print res.getString(1);
>
> pause;
> }
> Best regards,
> Liviu
>
> daniellim_yh <[EMAIL PROTECTED]> wrote:
> hi there,
>
> anyone have idea how to call an oracle 9's stored
> procedure? from
> connection setup until the calling syntax?thx in
> advance.
>
>
> daniel
>
>
>
>
>
>
>
>
> SPONSORED LINKS
> Computer part Programming languages
> Microsoft axapta Support exchange
>
> ---------------------------------
> YAHOO! GROUPS LINKS
>
>
> Visit your group "development-axapta" on the
> web.
>
> To unsubscribe from this group, send an email
> to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
> ---------------------------------
>
>
>
>
>
> ---------------------------------
> Yahoo! Mail
> Bring photos to life! New PhotoMail makes sharing a
> breeze.
>
> [Non-text portions of this message have been
> removed]
>
>
>
>
>
> SPONSORED LINKS
> Computer part Programming languages
> Microsoft axapta Support exchange
>
> ---------------------------------
> YAHOO! GROUPS LINKS
>
>
> Visit your group "development-axapta" on the
> web.
>
> To unsubscribe from this group, send an email
> to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
> ---------------------------------
>
>
>
>
>
> ---------------------------------
> Yahoo! Mail
> Use Photomail to share photos without annoying
> attachments.
>
> [Non-text portions of this message have been
> removed]
>
>
>
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
SPONSORED LINKS
| Computer part | Programming languages | Microsoft axapta |
| Support exchange |
YAHOO! GROUPS LINKS
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
