Still having oracle schema issues....

View: New views
7 Messages — Rating Filter:   Alert me  

Still having oracle schema issues....

by Jonathan Kushner-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hi. I am not getting the same output from Zend_Db_Oracle as I do with my $db object. If this seems to be a problem, then I would like to know if it is possible for me to use the profiler on my own db oracle object. I was thinking today that I would probably just extend my object off oracle_adapter to make it zend_interface profiling compliant. Can you guys please help, because this is getting annoying already. If you would like any specific information, please let me know and I will do my best to get you what you need.

 

 

Thank you,

 

 

Jonathan

 

 

 


RE: Still having oracle schema issues....

by Jonathan Kushner-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.

Just wanted to add… I didn’t mean the annoying part. I probably could just as easily do a diff on the connection, and extend off zend oracle… I just would rather not do that right this second.

 

Sorry about that.

 

-Jonathan

 

From: Jonathan Kushner [mailto:jkushner@...]
Sent: Wednesday, June 04, 2008 8:29 PM
To: fw-db@...
Subject: [fw-db] Still having oracle schema issues....

 

Hi. I am not getting the same output from Zend_Db_Oracle as I do with my $db object. If this seems to be a problem, then I would like to know if it is possible for me to use the profiler on my own db oracle object. I was thinking today that I would probably just extend my object off oracle_adapter to make it zend_interface profiling compliant. Can you guys please help, because this is getting annoying already. If you would like any specific information, please let me know and I will do my best to get you what you need.

 

 

Thank you,

 

 

Jonathan

 

 

 


Re: Still having oracle schema issues....

by Gabriel Baez-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I use Oracle and never had a problem with output.

On Thu, Jun 5, 2008 at 12:47 AM, Jonathan Kushner <jkushner@...> wrote:

Just wanted to add… I didn't mean the annoying part. I probably could just as easily do a diff on the connection, and extend off zend oracle… I just would rather not do that right this second.

 

Sorry about that.

 

-Jonathan

 

From: Jonathan Kushner [mailto:jkushner@...]
Sent: Wednesday, June 04, 2008 8:29 PM
To: fw-db@...
Subject: [fw-db] Still having oracle schema issues....

 

Hi. I am not getting the same output from Zend_Db_Oracle as I do with my $db object. If this seems to be a problem, then I would like to know if it is possible for me to use the profiler on my own db oracle object. I was thinking today that I would probably just extend my object off oracle_adapter to make it zend_interface profiling compliant. Can you guys please help, because this is getting annoying already. If you would like any specific information, please let me know and I will do my best to get you what you need.

 

 

Thank you,

 

 

Jonathan

 

 

 



RE: Still having oracle schema issues....

by Jonathan Kushner-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.

Are you using multiple schemas?

 

From: Gabriel Baez [mailto:sheik316@...]
Sent: Sunday, June 08, 2008 5:34 AM
To: Jonathan Kushner
Cc: fw-db@...
Subject: Re: [fw-db] Still having oracle schema issues....

 

I use Oracle and never had a problem with output.

On Thu, Jun 5, 2008 at 12:47 AM, Jonathan Kushner <jkushner@...> wrote:

Just wanted to add… I didn't mean the annoying part. I probably could just as easily do a diff on the connection, and extend off zend oracle… I just would rather not do that right this second.

 

Sorry about that.

 

-Jonathan

 

From: Jonathan Kushner [mailto:jkushner@...]
Sent: Wednesday, June 04, 2008 8:29 PM
To: fw-db@...
Subject: [fw-db] Still having oracle schema issues....

 

Hi. I am not getting the same output from Zend_Db_Oracle as I do with my $db object. If this seems to be a problem, then I would like to know if it is possible for me to use the profiler on my own db oracle object. I was thinking today that I would probably just extend my object off oracle_adapter to make it zend_interface profiling compliant. Can you guys please help, because this is getting annoying already. If you would like any specific information, please let me know and I will do my best to get you what you need.

 

 

Thank you,

 

 

Jonathan

 

 

 

 


RE: Still having oracle schema issues....

by Jonathan Kushner-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.

If so, can you share how you connect to a particular schema. I cannot locate this info on zend_db documentation.

 

From: Jonathan Kushner [mailto:jkushner@...]
Sent: Sunday, June 08, 2008 6:19 PM
To: Gabriel Baez
Cc: fw-db@...
Subject: RE: [fw-db] Still having oracle schema issues....

 

Are you using multiple schemas?

 

From: Gabriel Baez [mailto:sheik316@...]
Sent: Sunday, June 08, 2008 5:34 AM
To: Jonathan Kushner
Cc: fw-db@...
Subject: Re: [fw-db] Still having oracle schema issues....

 

I use Oracle and never had a problem with output.

On Thu, Jun 5, 2008 at 12:47 AM, Jonathan Kushner <jkushner@...> wrote:

Just wanted to add… I didn't mean the annoying part. I probably could just as easily do a diff on the connection, and extend off zend oracle… I just would rather not do that right this second.

 

Sorry about that.

 

-Jonathan

 

From: Jonathan Kushner [mailto:jkushner@...]
Sent: Wednesday, June 04, 2008 8:29 PM
To: fw-db@...
Subject: [fw-db] Still having oracle schema issues....

 

Hi. I am not getting the same output from Zend_Db_Oracle as I do with my $db object. If this seems to be a problem, then I would like to know if it is possible for me to use the profiler on my own db oracle object. I was thinking today that I would probably just extend my object off oracle_adapter to make it zend_interface profiling compliant. Can you guys please help, because this is getting annoying already. If you would like any specific information, please let me know and I will do my best to get you what you need.

 

 

Thank you,

 

 

Jonathan

 

 

 

 


Re: Still having oracle schema issues....

by Gabriel Baez-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

no, but if you want to select data from other schemas you should try   select * from  schemaname.tablename    sorry for the late responce.

On Sun, Jun 8, 2008 at 8:27 PM, Jonathan Kushner <jkushner@...> wrote:

If so, can you share how you connect to a particular schema. I cannot locate this info on zend_db documentation.

 

From: Jonathan Kushner [mailto:jkushner@...]
Sent: Sunday, June 08, 2008 6:19 PM
To: Gabriel Baez


Cc: fw-db@...
Subject: RE: [fw-db] Still having oracle schema issues....

 

Are you using multiple schemas?

 

From: Gabriel Baez [mailto:sheik316@...]
Sent: Sunday, June 08, 2008 5:34 AM
To: Jonathan Kushner
Cc: fw-db@...
Subject: Re: [fw-db] Still having oracle schema issues....

 

I use Oracle and never had a problem with output.

On Thu, Jun 5, 2008 at 12:47 AM, Jonathan Kushner <jkushner@...> wrote:

Just wanted to add… I didn't mean the annoying part. I probably could just as easily do a diff on the connection, and extend off zend oracle… I just would rather not do that right this second.

 

Sorry about that.

 

-Jonathan

 

From: Jonathan Kushner [mailto:jkushner@...]
Sent: Wednesday, June 04, 2008 8:29 PM
To: fw-db@...
Subject: [fw-db] Still having oracle schema issues....

 

Hi. I am not getting the same output from Zend_Db_Oracle as I do with my $db object. If this seems to be a problem, then I would like to know if it is possible for me to use the profiler on my own db oracle object. I was thinking today that I would probably just extend my object off oracle_adapter to make it zend_interface profiling compliant. Can you guys please help, because this is getting annoying already. If you would like any specific information, please let me know and I will do my best to get you what you need.

 

 

Thank you,

 

 

Jonathan

 

 

 

 



Re: Still having oracle schema issues....

by EricJ :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I'm using an Oracle db object to try and insert using a schema name...

$db= ZendDb::factory('Oracle');

$db->insert('SCHEMA.TABLE', $params);


And I'm getting the 'Table or view does not exist' error. Is this usage supported by Zend_Db? Or how can I insert using a schema name? The workaround I'm going to try next is to create a Zend_Db_Table subclass since it looks like it allows you to specify schema name, but I'd like to avoid doing that in this case.




Gabriel Baez-2 wrote:
no, but if you want to select data from other schemas you should try
select * from  schemaname.tablename    sorry for the late responce.

On Sun, Jun 8, 2008 at 8:27 PM, Jonathan Kushner <jkushner@bluehornet.com>
wrote:

>  If so, can you share how you connect to a particular schema. I cannot
> locate this info on zend_db documentation.
>
>
>
> *From:* Jonathan Kushner [mailto:jkushner@bluehornet.com]
> *Sent:* Sunday, June 08, 2008 6:19 PM
> *To:* Gabriel Baez
> *Cc:* fw-db@lists.zend.com
> *Subject:* RE: [fw-db] Still having oracle schema issues....
>
>
>
> Are you using multiple schemas?
>
>
>
> *From:* Gabriel Baez [mailto:sheik316@gmail.com]
> *Sent:* Sunday, June 08, 2008 5:34 AM
> *To:* Jonathan Kushner
> *Cc:* fw-db@lists.zend.com
> *Subject:* Re: [fw-db] Still having oracle schema issues....
>
>
>
> I use Oracle and never had a problem with output.
>
> On Thu, Jun 5, 2008 at 12:47 AM, Jonathan Kushner <jkushner@bluehornet.com>
> wrote:
>
> Just wanted to add… I didn't mean the annoying part. I probably could just
> as easily do a diff on the connection, and extend off zend oracle… I just
> would rather not do that right this second.
>
>
>
> Sorry about that.
>
>
>
> -Jonathan
>
>
>
> *From:* Jonathan Kushner [mailto:jkushner@bluehornet.com]
> *Sent:* Wednesday, June 04, 2008 8:29 PM
> *To:* fw-db@lists.zend.com
> *Subject:* [fw-db] Still having oracle schema issues....
>
>
>
> Hi. I am not getting the same output from Zend_Db_Oracle as I do with my
> $db object. If this seems to be a problem, then I would like to know if it
> is possible for me to use the profiler on my own db oracle object. I was
> thinking today that I would probably just extend my object off
> oracle_adapter to make it zend_interface profiling compliant. Can you guys
> please help, because this is getting annoying already. If you would like any
> specific information, please let me know and I will do my best to get you
> what you need.
>
>
>
>
>
> Thank you,
>
>
>
>
>
> Jonathan
>
>
>
>
>
>
>
>
>
LightInTheBox - Buy quality products at wholesale price