webdb | The Web is your database | Database library

i'm trying to create a web server that saves variables to a webserver on each situation, due to caching is it possible?, like res.send(data) i'm trying to make something like webdb(not sure if works)

This Webserver Uses Express edit: SOLVED _

Can anyone help? How to count data from the "web" database Sitecore?

I don't understand what undef is doing in this snippet:

I've been able to setup my Visual Studio (2019) Database Project up and using database references fine for tables, stored procedures, views, etc. They all seem to match up fine with the schema I've imported. However, I can't seem to avoid errors when it comes to referencing the same database's contracts, types, services, etc. When I reference the target database's service I have no issue (I assume this is because it accepts basic NVARCHAR strings versus a strongly-typed schema.

I've got the following example that just sends a message to another database's service. I get the error: "SQL71502: Procedure: [dbo].[z_Queue_SendMessage] has an unresolved reference to object [@VariableName]" with @VariableName being all of the following: (@RequestMessageType, @BasicContract, @InitiatorService)

I have a problem with encoding in ORACLE APEX app builder. When I'm using a app builder and creating for example a list with entry with polish native chars for example "Otwórz". When i save it it appears on list as "OtwA3rz". So I'm thinking about problem with encoding, but when i use "Grid Edit" on list I can easily use "Otwórz" and save it properly. After that there is a problem with edit this entry in form. Additionally when I create a form with for example textarea in my app there is no problem to save a value with polish chars. There is only a problem with app builder.

Some info from "About Application Express" modul:

• Product Build 19.2.0.00.18

• Schema Compatibility 2019.10.04

• Last DDL Time 02/05/2020 01:09:01 PM

• Host Schema APEX_PUBLIC_USER

• Application Owner APEX_190200

• Language Preference en

• Current Time (on server) 03/16/2020 02:17:08 PM +01:00

• APEX_LISTENER_VERSION 19.2.0.r1991647

• PLSQL_GATEWAY WebDb

• GATEWAY_IVERSION 3

• SERVER_SOFTWARE Mod-Apex

• GATEWAY_INTERFACE CGI/1.1

• REQUEST_METHOD GET

• QUERY_STRING p=4350:9:956788024708&p_dialog_cs=e6pVbBxXQReCPpEOwNEhrbAjoGPeY7nX6VVuLL8ObTSnXKlihOrJCOR8f1EU9isYxMT5Ooqgb-j9A33Mmx1aKA

• PATH_INFO /f

• HTTP_USER_AGENT Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.121 Safari/537.36

• HTTP_ACCEPT_ENCODING gzip, deflate, br

• HTTP_ACCEPT_LANGUAGE pl-PL,pl;q=0.9,en-US;q=0.8,en;q=0.7

• REQUEST_CHARSET AL32UTF8

• REQUEST_IANA_CHARSET UTF-8 • Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

• CORE 12.2.0.1.0 Production

• NLSRTL Version 12.2.0.1.0 - Production

• PL/SQL Release 12.2.0.1.0 - Production

• TNS for Linux: Version 12.2.0.1.0 - Production

• NLS_CHARACTERSET: EE8MSWIN1250

• DAD CHARACTERSET: UTF-8

• JOB_QUEUE_PROCESSES: 15

I noticed that when I run a sql select 'ó' from dual the result is exactly 'A3'. I run another select * from V$NLS_PARAMETERS; and maybe find a reason of all of this. NLS_LANGUAGE is AMERICAN. How to change it for POLISH like I have normally database session configured. When I create my own app with globalization setting there is no problem with setting nls_language to Polish. But i don't know how to change it for app builder

I made a additional experiment i run insert into table value 'ł' and select * from v$nls_parameters thru sql_workshop and sql_script: and below are results: (syntax parameter:value:method(script or sqlworkshop))